LOWER

The LOWER function returns a string where all letters are lowercase.

This function can be useful when you need to standardize the format of text, for example, for data processing or report preparation.

Syntax

LOWER(string)

Argument	Description	Permitted values
string	Text string that needs to be lowercase	Text string or reference to a cell containing text

Examples of use

Convert text to lowercase

If cell A1 contains the text “Hello, WORLD”:

=LOWER(A1)

The result: "hello, world".

Combining with other functions

If you want to combine several text strings and convert them to lowercase:

=LOWER(CONCATENATE("HELLO, ", "WORLD"))  

The result: "hello, world".

Notes

• The LOWER function is useful for processing data when it is important for the text to be in one case, for example, when comparing strings.
• If the text is already in lowercase, the function will not change it.