Not
Åtkomst till denna sida kräver auktorisation. Du kan prova att logga in eller byta katalog.
Åtkomst till denna sida kräver auktorisation. Du kan prova att byta katalog.
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])