Spread Formula Reference
LOWER
Formula Functions > Functions H to L > LOWER

This function converts text to lower case letters.

Syntax

LOWER(string)

Arguments

The argument is the text you want to convert to lower case. This function does not change characters in value that are not letters.The argument may be a string, a reference to a cell containing a string, or a formula that returns a string.

Data Types

Accepts string data. Returns string data.

Examples

LOWER(A4)

LOWER(R4C1)

LOWER(""Road Race 2"") gives the result road race 2

LOWER(CONCATENATE(A1,A5))

Version Available

This function is available in product version 1.0 or later.

See Also

UPPER | T | Text Functions