Converts all uppercase letters in a text string to lowercase.
Syntax
LOWER(text)
Text is the text you want to convert to lowercase. LOWER does not change characters in text that are not letters.
Example
| Col1 | Formula | Description (Result) |
|---|---|---|
| E. E. Cummings | =LOWER([Col1]) | Lower case of string (e. e. cummings) |
| Apt. 2B | =LOWER([Col1]) | Lower case of string (apt. 2b) |