Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Converts all letters in a text string to lowercase.
Syntax
LOWER(<text>)
Parameters
Term |
Definition |
|---|---|
text |
The text you want to convert to lowercase, or a reference to a column that contains text. |
Property Value/Return Value
Text in lowercase.
Remarks
Characters that are not letters are not changed. For example, the formula =LOWER("123ABC") returns 123abc.
Example
The following formula gets each row in the column, [ProductCode], and converts the value to all lowercase. Numbers in the column are not affected.
=LOWER('New Products'[ProductCode])