How to use UPPERCASE function in Microsoft Excel

 

In this article, we’ll learn how to use the UPPER function in Excel.

The Excel UPPER function converts all letters to uppercase in a string.

image 1

 

 

Let’s understand how this function works, with the help of examples.

image 2

 

1st Example:-

In the first example, we’ll learn how to convert text from small letter to capital letter.

image 3

 

Follow the steps given below:-

  • Enter the function in cell B8
  • =UPPER(A8), Press Enter

image 4

 

The Function has converted the text “EXCEL” in uppercase.

 

2nd Example:-

In this example, we’ll see what happens if we have text with only 1st letter in uppercase and remaining  in lowercase.

image 5

 

Follow the steps given below:-

  • Enter the function in cell B9
  • =UPPER(A9), Press Enter

image 6

 

The Function has changed all the letters in capital letters.

 

3rd Example:-

In this example, we have taken text which is already in capital letters. Let’s see what happens when we enter the UPPER function.

image 7

 

Follow the steps given below:-

  • Enter the function in cell B10
  • =UPPER(A10), Press Enter

image 8

 

This time function has returned the exact output which is there in cell A10 because, all the letters are already in upper case which is why the function did not change anything and returned as is.

 

4th Example:-

In this example, we have taken text along with special character.

image 9

 

Follow the steps given below:-

  • Enter the function in cell B11
  • =UPPER(A11), Press Enter

image 10

 

The function only changes the text and the special character and numbers remain unaffected. That’s because function only converts the letters and number or special characters remain unaffected.

So, this is how UPPER function works in different ways.

 

image 48

 

Video: How to use UPPER function in Microsoft Excel

Click on the video link for quick reference to the use of UPPER function. Subscribe to our new channel and keep learning with us!

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook

We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 
 



Example:


7 thoughts on “How to use UPPERCASE function in Microsoft Excel

  1. This tip works when converting a single cell, but I cannot find how to convert an entire worksheet like I can in WORD. I tried entering =UPPER(A1:J254) but it did not work. My data list is a chart of names and addresses with columns of figures and I want to change the text parts to upper case.

  2. when I enter this formula I get a circular reference. How do I get rid of that. I also would like to convert entire columns at one time. Anyone got the solution.

  3. This tip works when converting a single cell, but I cannot find how to convert an entire worksheet like I can in WORD. I tried entering =UPPER(A1:J254) but it did not work. My data list is a chart of names and addresses with columns of figures and I want to change the text parts to upper case.

  4. I could not get this to work at all. If any one know a way to convert entire columns to upper case, it would save me a lot of time. thanks.

  5. “1 if u want column a from 1-10 then copy cell a1 to b1
    2 apply upper formula
    3 copy formula in b1 to all rows till b10
    4 copy b1-b10 and paste-special–> values at position a1
    UPPPER CASE FOR COLUMNS
    WBl77 Posted on: 31-12-1969
    YOU CAN USE THE UPPER FORMULA ON THE FIRST CELL, AND THEN USE THE SMALL + AT THE BOTTOM OF THE CELL TO GO TO THE BOTTOM OF THE COLUMN. THIS WILL REPLACE ALL OF THE VALUES IN THE FORMULA WITH THE CELL NUMBERS FOR THE RANGE YOU HIGHLIGHT. THEN JUST REPEAT FOR EACH COLUMN”

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>