LOWER
Functions to Convert Between Upper & Lower Case
Basic Description
The Excel Lower function converts all characters in a supplied text string to lower case.
The format of the function is :
LOWER( text )
Where the text argument is the original text string, that you want to convert to lower case.
Lower Function Examples
The spreadsheet below shows four examples of the Lower function.
The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.
Further information and examples of the Excel Lower function are provided on the Microsoft Office website.