Rational
Converts text to uppercase.
Description
The Excel UPPER function converts all letters in the text to uppercase. For example, “=UPPER(“Hello World”)” returns ” HELLO WORLD”.
Syntax
=UPPER (text)
Parameters
text – The text to convert upper case
Return Value
Same text in upper case
Key Notes
- All letters in text switch to uppercase. To convert characters to lowercase use the LOWER function.
- The UPPER function accepts the text entered manually.
- Non-Alphabetical characters are not affected.
Keep Reading Similar Functions:
PROPER
The PROPER function capitalizes the first letter of each word in a given alphabetical text. I.e., =PROPER(“michael jackson”) returns “Michael Jackson”.
REPLACE
The REPLACE function substitute part of a text string with a new text string. I.e., =REPLACE(“Michael Jackson”,9,6,”Jorda”) returns “Michael Jordan”.
LOWER
The Excel LOWER function converts all letters in the text to lowercase. For example, “LOWer” returns “lower”.