LOWER Function
Returns a string converted to lowercase.
Syntax
LOWER(expression)
Parameters
Name | Required/Optional | Data Type | Description |
---|---|---|---|
expression |
Required |
Varies |
A string, a cell reference, or an expression; the result is converted to a string which is then converted to lowercase. |
Return value
String
Remarks
The case conversion is locale-specific, based on the current user settings.
Example
LOWER("mIxEd CAse")
Returns "mixed case".