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".