UPPER

Converts text to uppercase in Excel
Converts text to uppercase

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:

Capitalizes the first letter of each word in Excel

PROPER

The PROPER function capitalizes the first letter of each word in a given alphabetical text. I.e., =PROPER(“michael jackson”) returns “Michael Jackson”.

Read More »
To replace part of a text string in Excel

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”.

Read More »
Convert string or text to Lowercase in Excel

LOWER

The Excel LOWER function converts all letters in the text to lowercase. For example, “LOWer” returns “lower”.

Read More »