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

Formula

Description

Result

=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