The Excel LOWER Function

Basic Description

The Excel Lower function converts all characters in a supplied text string to lower case.

The syntax 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

In the spreadsheet below, the Excel Lower function is used to convert four text strings to lower case:

 Formulas:
 AB
1test=LOWER( A1 )
2TEST=LOWER( A2 )
3Test=LOWER( A3 )
4TEST 332=LOWER( A4 )
 Results:
 AB
1testtest
2TESTtest
3Testtest
4TEST 332test 332

Further details and examples of the Excel Lower function are provided on the Microsoft Office website.