The Excel LOWER Function

Related Functions:
PROPER Function
UPPER Function

Function 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:
  A B
1 test =LOWER( A1 )
2 TEST =LOWER( A2 )
3 Test =LOWER( A3 )
4 TEST 332 =LOWER( A4 )
 Results:
  A B
1 test test
2 TEST test
3 Test test
4 TEST 332 test 332

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