LOWER

See also A-Z Spreadsheet Function List

Description Changes the characters in the specified string to lowercase characters. Numeric characters in the string are not changed.

Syntax LOWER(text)

text is any string.

See Also PROPER and UPPER functions

Examples LOWER(“3rd Quarter”) returns “3rd quarter”

         LOWER(“JOHN DOE”) returns “john doe”