The Excel UPPER function converts every letter in a text string to capitals — one argument, no options, works in every version of Excel ever shipped. It is the standard fix for inconsistent codes, state abbreviations, and IDs typed by six different people in six different styles. Its siblings are LOWER (all lowercase) and PROPER (Each Word Capitalized).
=UPPER("sku-1042w") returns SKU-1042W.
Syntax
| Argument | Description | |
|---|---|---|
text | Required | The text to convert — a string in quotes, a cell reference, or another formula’s result. Non-letter characters are returned as-is. |
Available in: every version of Excel, Excel for the web, and Google Sheets. UPPER only touches letters — numbers, symbols, and spacing are untouched, and a number passed to UPPER comes back as text.
Standardize messy text
Six people typed product codes six different ways. One helper column makes them identical:
| A | B | |
|---|---|---|
| 1 | Raw entry | =UPPER(A2) |
| 2 | sku-1042-w | SKU-1042-W |
| 3 | Sku-1043-e | SKU-1043-E |
| 4 | sKU-1044-N | SKU-1044-N |
| 5 | tx — dallas hub | TX — DALLAS HUB |
To replace the originals, copy the helper column, then Paste Special › Values over column A and delete the helper. In Excel 365 one formula converts the whole column at once:
Try it: interactive UPPER demo
Type anything and watch UPPER convert it — LOWER and PROPER are shown alongside for comparison.
Cleanup combos: TRIM, comparisons, and keys
Imported text usually needs more than capitals. The classic one-two punch trims stray spaces and standardizes case in a single pass:
Excel’s = comparison is already case-insensitive, but the case-sensitive EXACT function is not — wrap both sides in UPPER when you want EXACT to ignore case:
UPPER also shines when building IDs and keys from pieces of other cells:
Want capitals for display only? There is no “all caps” cell format in Excel (unlike Word). UPPER in a helper column — or a font that only has capital glyphs — are the real options.
Errors & common pitfalls
Pitfall: UPPER doesn’t change the original cell. Like every formula, it returns a converted copy. To overwrite the source data: helper column → copy → Paste Special › Values → delete the helper.
Pitfall: numbers come back as text. =UPPER(B2) on the number 1042 returns the text “1042” — left-aligned and ignored by SUM. Only run UPPER on actual text, or wrap the result in VALUE if math must follow.
Pitfall: you may not need UPPER at all. =A2="dallas" already matches “DALLAS”, and XLOOKUP, VLOOKUP, and MATCH are case-insensitive too. UPPER is for standardizing stored data, not for making lookups work.
#NAME? — typo or missing quotes. UPPER exists everywhere, so #NAME? almost always means the function name is misspelled or a literal string argument is missing its quotes: =UPPER(texas) instead of =UPPER("texas").
Practice workbook
Frequently asked questions
How do I make an entire column uppercase at once?
=UPPER(A2:A500). In older versions, enter =UPPER(A2) and double-click the fill handle to copy it down.How do I replace the original text instead of using a second column?
Does UPPER affect numbers, dates, or punctuation?
Is there a keyboard shortcut for uppercase like Shift+F3 in Word?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class