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:

Excel UPPER - How to use the Excel UPPER function

Syntax:  =UPPER(A2)

Result:

Excel UPPER Function - How to use the Excel UPPER function

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

Syntax: =UPPER(A3)
Result: UPPER FUNCTION IN EXCEL

Syntax: =UPPER(A4)
Result: SO PHUC.COM

Syntax: =UPPER(A5)
Result: UPPER IN EXCEL

Syntax: =UPPER(A6)
Result: SO PHUC

Syntax: =UPPER(A7)
Result: UPPER FUNCTION EXCEL

Syntax: =UPPER(A8)
Result: EXCEL VBA UPPER

Syntax: =UPPER(A9)
Result: UPPER EXCEL

Note:

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

Add a Comment

Your email address will not be published. Required fields are marked *