Using the Excel UPPER Function

Summary
The Excel UPPER function will convert all lowercase letters in a text string to uppercase letters.Syntax
=UPPER (text)Syntax Breakdown
TextRequired. The text that will be changed to uppercase. The function has no affect on characters in text that are not letters. The argument can be a reference or a text string.
Usage Notes
UPPER changes lowercase letters in a text string to uppercase letters. Non-text characters, such as punctuation and numbers, are not affected.To convert uppercase letters to lowercase, use the LOWER function.