LOWER function
Returns a string converted to lowercase.
Syntax
|
LOWER(expression) | |
|
expression |
A string, a cell reference, or an expression; the result is converted to a string which is then converted to lowercase. |
Remarks
The case conversion is locale specific, based on the current user settings.
Example
LOWER("mIxEd CAse")
Returns "mixed case".