UPPER Function in Excel: Syntax, Examples and Free Practice
UPPER is an Excel Text function. Converts text to all uppercase.
UPPER syntax
=UPPER(text)
Arguments
text: The text to work with
When to use UPPER
UPPER is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice UPPER online, free
Open the live Excel-style spreadsheet and try UPPER yourself. No Excel install or sign-up needed to start.
Practice UPPER now →Watch: UPPER in Excel
More Text functions
Frequently asked questions
What does the UPPER function do in Excel?
Converts text to all uppercase.
What is the syntax of UPPER in Excel?
The syntax is =UPPER(text). text: The text to work with.
Where can I practice UPPER online for free?
Open the free live spreadsheet on Cellgrids and try UPPER yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts