LOWER

Name

Lower

Description

Converts text to lowercase letters.

Syntax

LOWER(value)

Remarks

The value argument is the text you want to convert to lowercase. The LOWER function does not change characters in value that are not letters.

The value argument can be a string, a formula that returns a string, or a reference to a cell containing a string.

See also CHAR, LEFT, MID, PROPER, RIGHT, and UPPER.

Data Type

Accepts string data. Returns string data. For more information, see Data Type for Each Cell Type.

Example

fpSpread1.Formula = "LOWER(""Road Race 2"")" equals "road race 2"