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.
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.
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.