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:
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”.
PROPER
The PROPER function capitalizes the first letter of each word in a given alphabetical text. I.e., =PROPER(“michael jackson”) returns “Michael Jackson”.