How to use UPPER function in Microsoft Excel

The UPPER function in excel is used to capitalize all letters of a string. In this article, we will explore how you can use UPPER function to do some really important tasks. Let’s get started.
Excel UPPER Function Syntax

=UPPER(text)

Text: it is the text or string that you want to capitalize.
Excel Upper Example 1:
In this example, we just want to get upper case input from the user. So in a column, a user will enter their name. It can be in lower, upper, proper or irregular styled text. In Column B, we just want the upper case text of the A column.
41
Write the below formula in B1 and copy down.

=UPPER(A2)

42
Excel UPPER Example 2: Getting Only Upper Case Inputs
Many times you would want the user to input only UPPER case letters. In this case, we would put a data validation in excel.
Here, we have a column called verification code. Let’s say you have some guest invited in secret party. Now you have cent they the secret code. They will enter their secret code in excel column. The trick is, each code should be in UPPER case. So if any user puts a non upper input, it will show error.
43

    1. Select first cell, Here A2.
    2. Go to Data tab ? Data validation ?
    3. Select Custom

44

  1. Write this formula in formula section. Click OK. Copy this cell down.
=EXACT(A2,UPPER(A2))

45
Now try to enter any text that is non-upper case.
46
It will not accept the input.
How it Works
Here, we compare text entered in cell, with upper case of that text using EXACT function. If they don’t match, excel shows invalid input prompt.

So yeah guys, this how you use UPPER function in excel. Let me know if you have any doubt about this function of excel in the comments section below.

Related Articles:

How to Use LOWER function in Excel

How to Use PROPER function in Excel

How to use EXACT Function in Excel

How to do Case Sensitive Lookup in Excel

Popular Articles:

The VLOOKUP Function in Excel

COUNTIF in Excel 2016

How to Use SUMIF Function in Excel

 

Users are saying about us...

  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 *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube