The UPPER function converts a text into uppercase. In this guide, we’re going to show you how to use this function and cover some tips and error handling methods.
Supported versions
- All Excel versions
Syntax
UPPER(text)
Arguments
text |
The text you want converted to uppercase. |
Examples
Example 1
=UPPER("Charizard")
Example 2
=UPPER(Id&" - "&Name&" - "&Type)
Tips
- Try LOWER function to convert strings into lowercase.
- Try PROPER function to capitalize the first letter of each word in a text.