Learn How to Use Microsoft Excel UPPER Function

Microsoft Excel UPPER Function

The primary purpose of the Microsoft Excel UPPER function is to convert text into an upper-case. That means with the help of the UPPER function; you can able to return the upper-case text version of the specified text string. The UPPER function does not affect the numbers and punctuations in the specified text string.

UPPER Function Return Value

It will return the uppercase text.

UPPER Function Syntax

= UPPER(text)

Where the argument:

• text: It is the text that you want to convert into uppercase.

How to Use Microsoft Excel UPPER Function?

You can able to convert all the text to the upper case. This will not affect the number and punctuation provided in the text string.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel