The LOWER function takes just one argument,text, which can be a text value or cell reference.

LOWER changes any uppercase characters in the text value to lowercase.

Numbers, punctuation, and spaces are not affected.

Excel formula: Count specific characters in text string

LOWER will convert numbers to text withnumber formattingremoved.

Numbers, punctuation, and spaces are not affected.

UPPER Function

The Excel UPPER function converts a text string to all uppercase letters.

Excel formula: Normalize text

Numbers, punctuation, and spaces are not affected.

PROPER Function

The Excel PROPER function capitalizes each word in a given text string.

Numbers, punctuation, and spaces are not affected.

Excel formula: Create email address from name

Article image

Article image

Excel LOWER function

Excel UPPER function

Excel PROPER function

Excel EXACT function