Excel LOWER function

Summary

The Excel LOWER function changes a text string to all lower case text string.

This function is useful for changing a text string to lower case characters for comparison purposes.

Function

=LOWER(text)

Arguments (inputs)

text = the text string, can be a cell reference or value

Return value

The LOWER function returns the same text string it is provided, but changed to an all lower case text string.

Example

In the example above the LOWER function changes the customer name from cell C6 “Claire Gute”, to all lower case characters.

=LOWER(C6)

The result returned is “claire gute”.