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.
Examples
| 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) |