The Excel Lower function converts all characters in a supplied text string to lower case.
The syntax of the function is:
Where the text argument is the original text string, that you want to convert to lower case.
In the spreadsheet below, the Excel Lower function is used to convert four text strings to lower case:
|
Formulas:
|
Results:
|
Further details and examples of the Excel Lower function are provided on the Microsoft Office website.