Excel LOWER Function

Using the Excel LOWER Function

Excel LOWER Function

Summary

The Excel LOWER function will convert all uppercase letters in a text string to lowercase letters.

Syntax

=LOWER (text)

Syntax Breakdown

Text
Required. The text that will be changed to lowercase. The function has no affect on characters in text that are not letters.

Usage Notes

LOWER changes uppercase letters in a text string to lowercase letters. Non-text characters, such as punctuation and numbers, are not affected.

To convert lowercase letters to uppercase, use the UPPER function.