How to Use Excel's UPPER Function

Excel's UPPER function converts the specified text to uppercase. It returns the specified text with all lowercase letters replaced by their uppercase equivalent. Characters that already are uppercase, or have no uppercase equivalent, will change.

Instructions

Difficulty: Challenging

1. Learn the syntax for UPPER. It is UPPER(test_text).
2. Specify test_text as the text to be converted to upper case. Test_text may be a reference or a string.
3. Compare UPPER to similar functions such as LOWER() and PROPER(). LOWER converts all text to lower case if not already in lower case and if the text has a lowercase equivalent. PROPER converts only the first letter of each word to upper case. The first character in a string is capitalized if possible as is every letter that follows a character that is not a letter.
4. Look at some straightforward examples on how UPPER is used.
   
   UPPER("test text") = TEST TEXT. Every letter was converted to upper case.
   UPPER("123456") = 123456. These character have no uppercase equivalent, so no change could be made.
   UPPER("TEST TEXT") = TEST TEXT. This text was already uppercase, therefore no changes were needed.
5. Examine some uses of UPPER on cells containing mixed text where A2 = "Upper Case Test" and B2 = "Abc123".
   
   UPPER(A2) = UPPER CASE TEST. This mixture of cases shows that each character is evaluated separately and converted to uppercase if needed.
   In UPPER(B2) = ABC123, "b" and "c" were capitalized but UPPER has no effect on numbers.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.