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