The UPPER formula in Excel is like a magic spell that can change the letters in your words to be all big and loud!
Let’s say you have a word “apple” written in your computer. But you want it to be in big letters, like “APPLE”. You can use the UPPER formula to make it happen!
All you have to do is type =UPPER(“apple”) in your computer and then press Enter. Voila! Your word “apple” will change to “APPLE”.
It’s like if you were to shout the word out loud, that’s how big the letters will be. Try it with your own words, it’s so much fun!
The UPPER formula in Excel is a handy tool that allows you to convert text strings to all uppercase letters. This can come in handy when you need to standardize data for sorting or comparison purposes or when you want to convert mixed-case text to all uppercase for formatting purposes.
To help you understand how the UPPER formula works, let’s look at a table with 5 sample rows.
The headers for the columns in the table are “Data”, “Formula”, and “Result”.
A | B | C | |
1 | Data | Formula | Result |
2 | New York | =UPPER(A2) | NEW YORK |
3 | MuMbai | =UPPER(A3) | MUMBAI |
4 | new Delhi | =UPPER(A4) | NEW DELHI |
5 | gurgaon | =UPPER(A5) | GURGAON |
The syntax for the UPPER formula is
=UPPER(text),
where “text” is the cell containing the text string you want to convert to uppercase letters.
In the table, the “Data” column (column A) contains the text strings, while the “Formula” column (column B) contains the UPPER formula using the text string from the corresponding row in column A. Finally, the “Result” column (column C) shows the final output of the UPPER formula, which is the text string in all uppercase letters.
As you can see from the example, the UPPER formula is a straightforward and effective tool for converting text strings to all uppercase letters. With just a single formula, you can quickly and easily standardize your data for sorting, comparison, or formatting purposes.
Use cases of UPPER formula in Excel:
- Standardizing data: One of the main use cases of the UPPER formula is to standardize data by converting all text strings to uppercase letters.
- Formatting text: Another use case of the UPPER formula is to convert mixed-case text to all uppercase for formatting purposes. This can be useful for making certain text stand out, such as headings or titles, or for creating a consistent look and feel in your worksheets.
