How to use the Excel UPPER function

The UPPER function is an Excel Text function, that will convert text to all capital letters (UPPERCASE). Thus, the function converts all characters in a supplied text string into upper case.

In financial analysis, we often import data from external sources. The UPPER function will help us convert text to upper case if required. It will not affect numbers and punctuations. Cleaning up data for analysis is often a very time-consuming step, Text functions are often great tools to speed up the process.

Syntax: =UPPER(text)

The UPPER function syntax has the following arguments:

• Text (Required) The text you want converted to uppercase. Text can be a reference or text string.

Example: Let’s look at some Excel UPPER function examples and explore how to use the UPPER function as a worksheet function in Microsoft Excel:

Syntax:  =UPPER(A2)

Result:

Based on the Excel spreadsheet above, the following UPPER examples would return:

Note:

• All letters in text are converted to upper case.
• Numbers and punctuation characters are not affected.