UPPER function takes just one argument,text, which can be a text value or cell reference.
UPPER changes any lowercase characters in the text value to uppercase.
Numbers, punctuation, and spaces are not affected.
UPPER 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.
