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")
formula returns "CHARIZARD" as text value.

UPPER Example 1

Example 2

=UPPER(Id&" - "&Name&" - "&Type)
formula returns "6 - CHARIZARD - FIRE, FLYING". The UPPER function can convert strings from references. It doesn't affect numbers, spaces or punctuation characters.

UPPER Example 2

Download Workbook


Tips

  • Try LOWER function to convert strings into lowercase.
  • Try PROPER function to capitalize the first letter of each word in a text.