How to use the UPPER function in Microsoft Excel

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

Summary

The Excel UPPER function will return the uppercase version of the text string given. Numbers and punctuation are not affected when we use UPPER function.
UPPER can be useful in arranging data or creating data in a certain format. For example, we often import data from external sources. The UPPER function will help us convert text to upper case if required.
The Upper function is a built-in function in Excel that is categorized as a Text Function.

Purpose

Convert text to upper case (capital letters).

Return value

Text in upper case

What Does It Do ?

This function converts all characters in a piece of text to upper case.

Syntax

Upper function has one syntax and hence they can be written in Two different ways:

=UPPER(text) or
=UPPER(cell reference)

Parameters or Arguments

Text: A Text which you want converts to upper case.
Cell reference: Reference to cells containing text.

Formatting

No special formatting is needed.

Usage notes

• All letters in text are converted to upper case.
• Numbers and punctuation characters are not affected when we use UPPER function.
• Anything other than letters will remain unaffected.
• If the referred text is an error it will return an error in the result.
• You can also insert text string directly into the function by using double quotation marks.

Click here to learn more excel function