LOWER function

Microsoft Office ShapeSheet

LOWER function

See also

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