Table of Contents
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”.
