Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
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])