Excel: Lower Function

In Excel, the Lower function converts all letters in the specified string to lowercase. If there are characters in the string that are not letters, they are unaffected by this function.

The syntax for the Lower function is:

Lower( text )

text is the string to convert to lowercase.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Lower(A1) would return "alphabet soup"

=Lower(A2) would return "techonthenet"

=Lower("Excel") would return "excel"