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
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.
Write the below formula in B1 and copy down.
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.
Now try to enter any text that is non-upper case.
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.
How to do Case Sensitive Lookup in Excel
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.