Subscribe for New Post Notifications


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:

UPPER function


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.


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.


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.


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.

No comments:

Post a Comment