UPPER in Excel: Syntax, Examples and Errors
Updated 2026-10-14 · Free · Works in Excel & Google Sheets
Syntax
=UPPER(text)Quick answer
UPPER converts text to capital letters: =UPPER(A2) turns "jane doe" into "JANE DOE". Only letters change — digits, spaces and punctuation pass through untouched — and the result is always text, which silently turns numbers into labels that no longer sum.
Syntax
=UPPER(text)| Argument | What it means |
|---|---|
| text | The cell or literal to convert to capital letters. Required — and the only argument. No count, no delimiter, nothing else to configure. |
With a single argument there is nothing to separate, so the semicolon question never comes up: =UPPER(A2) looks identical in every locale.
UPPER changes letters and only letters: "jane doe 2026!" becomes "JANE DOE 2026!". Accented characters gain their capital forms (é → É, ñ → Ñ, ç → Ç) in current Excel versions, and the length of the text never changes.
Basic examples
=UPPER(A2)The everyday case: mixed-case names become "JANE DOE", part codes line up as "AE-2026-041", and country or state abbreviations match their official uppercase forms — anywhere a downstream system expects capitals.
=UPPER(TRIM(A2))Clean-then-convert: TRIM strips leading, trailing and duplicated spaces first, so " jane doe " comes out as "JANE DOE" instead of " JANE DOE ". The two nest constantly on imported data.
=EXACT(A2, UPPER(A2))The uppercase check: TRUE only when the cell is already all capitals. Plain = cannot do this — Excel treats "abc" = "ABC" as equal — so EXACT is the only comparison that respects letter case.
=IF(EXACT(A2, UPPER(A2)), "OK", "Fix")Turns the check into a flag column: rows still needing normalization read "Fix", which is exactly what you want to see before an import into a case-sensitive system.
UPPER stringifies numbers: UPPER(12345) returns the text "12345" that no longer sums, and a date comes back as its serial number ("45658"), not a date. Keep numeric and date columns out of UPPER, or convert digits back with VALUE.
Common errors and how to fix them
| Symptom | Most common cause | Fix |
|---|---|---|
| The result cannot be summed or charted | UPPER converts numbers to text — UPPER(12345) is the label "12345", not the value. | Run UPPER only on genuine text columns. If digits must pass through, convert back with =VALUE(UPPER(A2)). |
| A date turns into something like 45658 | Dates are serial numbers under the hood; UPPER stringifies the serial, not the displayed date. | Exclude date columns from the conversion, or format the result as a date afterwards. |
| Nothing changed | The text was already uppercase — capitals pass through UPPER untouched. | Not an error. Prove it with =EXACT(A2, UPPER(A2)) and check for stray spaces with TRIM if the cell still looks off. |
| =A2=UPPER(A2) returns TRUE for "abc" | Excel’s = operator ignores case completely, so it cannot tell "abc" from "ABC". | Use =EXACT(A2, UPPER(A2)) — the only built-in comparison that respects letter case. |
| Blank rows stop being blank | UPPER of an empty cell returns "" — empty text, which no longer counts as blank for ISBLANK. | Guard it: =IF(A2="", "", UPPER(A2)) keeps genuinely empty rows empty. |
Not an error, but worth knowing: UPPER is one-way. It cannot capitalize only initials (that is PROPER), cannot undo itself (that is LOWER), and does not remove spaces (that is TRIM).
UPPER vs. LOWER and PROPER
| UPPER | LOWER | PROPER | |
|---|---|---|---|
| Converts to | ALL CAPITAL LETTERS | all lowercase | First Letter Of Each Word |
| "jane doe" becomes | "JANE DOE" | "jane doe" | "Jane Doe" |
| Typical job | Codes, IDs, country and state abbreviations, matching keys | Email addresses, usernames, lowercase system fields | Display names, addresses, titles |
| Known quirk | Numbers become text | Same | "McDonald" flattens to "Mcdonald", "USA" to "Usa" |
All three take exactly one text argument and always return text. Choose by audience: machines and joins prefer the uniform UPPER or LOWER, human eyes get PROPER — with manual fixes for the acronyms it flattens.
UPPER vs. Flash Fill
| UPPER formula | Flash Fill (Ctrl+E) | |
|---|---|---|
| Output | A live formula in a helper column; recalculates when the source changes | Static values, written once; new rows need a refill |
| Precision | Deterministic — every row, every time | Pattern-guessed — spot-check the result column |
| Best for | Repeating imports and reports that must stay current | One-time cleanups of a finished table |
| Available in | Every Excel version and Google Sheets | Excel 2013 and later; Sheets answers with Smart Fill |
Choose by lifespan: UPPER formulas for data that keeps arriving, Flash Fill for a one-time reshaping you will paste over. If you keep the formula route, paste values back once the column is final.
UPPER in Google Sheets
- Same name, same single argument — every formula above pastes into Sheets unchanged.
- The = ignores case / EXACT distinction behaves identically, so the uppercase check transfers as-is.
- Smart Fill (the Sheets answer to Flash Fill) also guesses an uppercase pattern — same caveat: it writes static values, not live formulas.
- Accented capitals (É, Ñ, Ç) come out correctly in both products; locale quirks only affect very old Excel versions.
Limitations and pro tips
- One job per call: UPPER cannot capitalize initials (PROPER), restore lowercase (LOWER) or remove spaces (TRIM) — stack them: =UPPER(TRIM(A2)).
- Case-sensitive checks need EXACT, not =: EXACT(A2, UPPER(A2)) is the true "is it all caps" test.
- For joins against case-sensitive systems, keep an UPPER helper column and point every consumer at it, so all sides see one canonical form.
- Blank cells become "" under UPPER — guard with IF(A2="", "", UPPER(A2)) when empties must stay empty.
- Paste values back: Copy the helper column → Paste Special → Values → delete the helper, so the table survives source-column cleanup.
Think of UPPER as the standardizing station of a cleaning line: TRIM the padding, UPPER the letters, EXACT-check the result, then paste values back. Each stage in its own column keeps the recipe auditable — and one formula away from a fix when the format shifts.
Related Tools
Related Functions
Frequently Asked Questions
What does the UPPER function do in Excel?
It converts every letter in a cell to capitals: =UPPER(A2) turns "jane doe" into "JANE DOE". Digits, spaces and punctuation pass through unchanged, accented letters gain their capital forms, and the result is always text.
How do I make an entire column uppercase?
Add a helper column with =UPPER(A2), fill it down, then Copy → Paste Special → Values over the original and delete the helper. Every row follows the same rule, which makes it safer than retyping or Find and Replace.
Why does UPPER turn my numbers into text?
UPPER is a text function: it receives 12345 and returns the label "12345", which no longer sums or charts. Dates come back as serial numbers ("45658"). Keep numeric and date columns out of UPPER, or convert digits back with VALUE.
How do I check whether a cell is already uppercase?
=EXACT(A2, UPPER(A2)) returns TRUE only when the text is already all capitals. Do not use =A2=UPPER(A2) — Excel’s equality operator ignores case, so it reports TRUE even for "abc" versus "ABC".
What is the difference between UPPER and PROPER?
UPPER makes every letter a capital; PROPER capitalizes only the first letter of each word and lowercases the rest. Codes and IDs take UPPER, display names take PROPER — remembering that PROPER flattens "McDonald" and "USA".
Does the equals sign distinguish letter case in Excel?
No — "abc" = "ABC" evaluates to TRUE because Excel compares text case-insensitively. The only built-in case-sensitive comparison is EXACT(A2, B2), which is why every uppercase check should use it.
Does UPPER work in Google Sheets?
Yes — same name, same single argument, same EXACT-based case checks. Sheets also offers Smart Fill as the Flash Fill alternative, with the same caveat that it writes static values instead of live formulas.
Ready to try it on your own file?
Open Change Case in Excel — It's Free