LOWER

Converts the letters of a given string to lowercase. To convert text to uppercase please refer to UPPER.

Syntax

=LOWER(Text)

Arguments

Name	Description
Text	A string to convert to lowercase

Return

Given text in lowercase.

Examples

Formula	Result	Comment
=LOWER("HeLLo!")	hello!	only affects letters in uppercase
=LOWER(A1)	hello world	assumes cell A1 contains text "Hello WORLD"