How to Use UPPER Excel Formula
Home >> Excel Tutorials from Compute Expert >> Excel Formulas List >> How to Use UPPER Excel Formula
In this tutorial, you will learn completely how to use the UPPER excel formula. This formula is useful to convert all letters in the data that becomes its input into uppercase letters.
Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more
Want to work faster and easier in Excel? Install and use Excel add-ins! Read this article to know the best Excel add-ins to use according to us!
Table of Contents:
- UPPER usefulness
- UPPER result
- Excel version in which the UPPER formula can start to be used
- The way to write it and its input
- Example of usage and result
- Writing steps
- Convert all letters into lowercase: LOWER
- Convert the first letter of each word into uppercase letters and other letters into lowercase: PROPER
- Exercise
- Additional Note
UPPER Usefulness
The UPPER formula is useful to convert all letters in data into uppercase letters.UPPER Result
The result you will get from UPPER is data with the letters in it are all uppercase letters.Excel Version in Which the UPPER Formula Can Start to Be Used
UPPER can start to be used since excel 2003.The Way to Write It and Its Input
The UPPER writing in excel can be illustrated as follows:
=UPPER(text)
As you can see above, the input needed by this formula writing is just one. It is text, the data you want to change all its letters into uppercase letters.
Example of Usage and Result
The following will give and explain the example of UPPER usage, its writing and the result you get from it.
In the example, we can see what is the change made by UPPER to data. UPPER will transform all letters in your data into uppercase letters. It won’t do anything to any other data types (numbers, spaces, etc).
The way to use this formula is pretty easy as you can see in the example. You just need to input the data which letters you want to convert into this formula. Press enter and the letters in the data will all be converted into uppercase letters!
Writing Steps
The following part will explain the steps to write the UPPER formula in excel. This formula is pretty easy to use because it only needs the data input in which its function will be applied.-
Type an equal sign ( = ) in the cell where you want to put the result of your UPPER
-
Type UPPER (can be with large and small letters) and an open bracket sign after =
-
Input the data or cell coordinate where the data you want to convert all the letters is. If you want to type it manually without using a cell coordinate, don’t forget to type the data between two quotes signs (“”)
-
Type a close bracket sign
- Press Enter
-
The process is done!
Convert All Letters into Lowercase: LOWER
Want to do the opposite of the UPPER function, which means converting all letters in data into lowercase letters? Use LOWER!The way to write LOWER is similar to UPPER. The input it needs is the same, which is the data in which you want to convert the letters. Generally, the way to write it can be illustrated as follows:
=LOWER(text)
And here is the example of the LOWER formula usage in excel and the result you get from it.
As you can see in the screenshot, LOWER does the opposite of UPPER. It converts all letters in data into lowercase letters. It also doesn’t do anything to data besides letters (numbers, spaces, etc won’t be changed after they are inputted into LOWER).
Need more explanation about this LOWER formula? Visit the tutorial that discusses it in detail here!
Convert the First Letter of Each Word into Uppercase Letters and Other Letters into Lowercase: PROPER
What if we want to convert a text into a title format? That means the first letters of each word in it are converted into uppercase letters and other letters into lowercase letters?There is also a formula to do that in excel, named PROPER.
The way to write PROPER and its input is similar to UPPER. Generally, here is the illustration of the PROPER writing in excel.
=PROPER(text)
And here is its usage example and the result you get from it.
In the example, you can see the PROPER result form and how the PROPER writing and input are similar to UPPER. PROPER will convert the first letter of each word in data into uppercase letters and other letters to lowercase letters. Like UPPER, the data form besides letters isn’t changed after it is inputted to PROPER.
If you want to learn deeper about PROPER, visit this tutorial!
Exercise
After you have learned how to use UPPER, now you can deepen your understanding about it by doing the exercise below.Download the exercise file and do all the instructions. Download the answer key file to check your answers if you have done the exercise. Or probably when you are confused about how to do the instructions!
Link to the exercise file:
Download here
Questions
Do all the following instructions in the gray-colored cell on the appropriate row number!- Use UPPER to convert all the letters in the first data on the left cell into uppercase letters! What is the result of the first data?
- Use UPPER to convert all the letters in the second data on the left cell into uppercase letters! What is the result of the second data?
- Write your name in small letters form as the input of your UPPER!
Link to the answer key file:
Download here
Additional Note
If you input a date into UPPER, then you will get its equivalent number in excel.Related tutorials you should learn:
