The Excel LOWER Function

Home » Excel-Built-In-Functions » Excel-Text-Functions » Excel-Lower-Function Search this site: Custom Search

Related Functions:  PROPER Function UPPER Function

Basic Description

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

The format of the function is :

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.

Formulas

Results

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