UPPER in Excel: Convert Text to Uppercase Letters
Converts text to uppercase.
How to Convert Text to Uppercase in Excel
The UPPER function converts all characters in a text string to capital letters. Numbers and punctuation marks remain unaffected.
Syntax & Arguments
=UPPER(text)
- text (Required): The text string or cell reference to capitalize.
Common Use Cases
- Standardizing state/country abbreviations (e.g., "ny" → "NY")
- Formatting SKU numbers, coupon codes, and serial numbers
Common Errors & Fixes
Text not converting to uppercase
Causes:- The cell contains numbers or special characters (UPPER ignores non-text).
- The formula is referencing the wrong cell.
Fixes:- Ensure the cell contains text values, not just numbers.
- Double-check the cell reference in the formula.
Frequently Asked Questions
Does UPPER work with accented characters?
Yes, UPPER converts accented characters like é to É and ñ to Ñ. It handles all Unicode letters properly.
What is the difference between UPPER, LOWER, and PROPER?
UPPER makes all letters uppercase. LOWER makes all letters lowercase. PROPER capitalizes the first letter of each word.
Does UPPER work in Google Sheets?
Yes, UPPER works identically in Google Sheets with the same syntax.
Related Formulas
Explore related formula generators to solve similar problems
🛠️ Related Tools
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More