Lower() function

The Microsoft Excel LOWER function converts all letters in the specified string to lowercase. Numbers and punctuation are not affected.

Syntax

The syntax for the LOWER function in Microsoft Excel is:

=LOWER( text )

Parameters or Arguments

text

The string to convert to lowercase.

Lower Function Examples

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

Formulas:

Results:

Excel Function Home

Text Functions