Converts all uppercase letters in a text string to lowercase.

Syntax

LOWER(value)

The LOWER function syntax has the following arguments:

  • value (Required) The text you want to convert to lowercase. LOWER does not change characters in text that are not letters.

Example

Field 1: E. E. Cummings
Field 2: Apt. 2B

FormulaDescriptionResult
=LOWER([Field 1])Lower case of first string (e. e. cummings)e. e. cummings
=LOWER([Field 2])Lower case of last string (apt. 2b)apt. 2b