Excel UPPER Function is a handy tool that helps you convert text to uppercase letters in a spreadsheet. It’s especially useful when you want to standardize the capitalization of text, making it all uppercase regardless of how it’s originally typed.
Syntax
UPPER(text)
Arguments
| text | The text you want to convert to uppercase. |
How to Use
Using the UPPER function is quite simple. You provide a cell reference or the text you want to convert to uppercase as the ‘text’ argument. Here are a few examples to illustrate its use:
|
1 |
=UPPER("hello") |
This formula will return “HELLO” as the output.
|
1 |
=UPPER(A2) |
If cell A2 contains the text “world,” this formula will return “WORLD” in the cell where it’s entered.
Remember, the UPPER function doesn’t change the original text in the cell. It only displays the uppercase version of the text in the cell where the formula is entered.
Examples
Here are a few more examples to show how the UPPER function works:
|
1 |
=UPPER("excel") |
This formula returns “EXCEL.”
|
1 |
=UPPER("123abc") |
It’s not just limited to alphabetic characters. This formula will return “123ABC” as the result.
|
1 |
=UPPER(A3) |
If cell A3 contains “MixedCase,” this formula will return “MIXEDCASE.”
Excel UPPER function can be a helpful tool when you need to ensure uniform capitalization in your data, making it easier to work with and present.