How To Use Excel UPPER Function –A Quick Guide

Sometimes we might want to convert the text to UPPER case irrespective of whatever case it has been entered as.

Excel UPPER function can be used to achieve the same.

Let’s see how to use it in detail…

1. What is the UPPER Function?
2. What is the Syntax?
3. How to use it with an example?

1. What is the UPPER Function?

An UPPER function can be used to convert the given text into upper case, ignoring numbers and punctuations.


2. What is the Syntax?

=UPPER(text)

  • text  = (Required) Text that we want to convert to upper case.

Note :

  • Any numbers or punctuations available in the text are ignored

3. How to use it with an example?

Suppose we have to convert some existing data to Upper case

let’s see how to do that…!!!

Excel UPPER function 1.PNG

**Explained**

=UPPER(B1)
  • B1 = Reference to the cell ,which we want to convert to UPPER case.

 

Hope it has helped you… 

Advertisements

Author: Sharath Raju

Founder@www.ExcelCult.com

Leave a Reply