Text

UPPER Function in Excel

Converts text to uppercase.

Syntax

  • =UPPER(text)

Arguments

  • text (required): The text to convert

Examples

  • =UPPER("hello") - Convert to uppercase - Result: HELLO
  • =UPPER(A1) - Uppercase cell content - Result: UPPERCASE TEXT

Excel UPPER function documentation

  • UPPER converts all letters in text to uppercase — numbers and symbols unchanged.
  • Syntax: =UPPER(text). Useful for normalizing keys before lookup or duplicate detection.
  • Case-insensitive compare pattern: =EXACT(UPPER(A2), UPPER(B2)).
  • Related: [LOWER](/functions/lower/), [PROPER](/functions/proper/), [TRIM](/functions/trim/).

UPPER syntax and normalization workflow

  • UPPER does not remove spaces — apply [TRIM](/functions/trim/) first: =UPPER(TRIM(A2)).
  • Locale-specific special characters may uppercase differently; test with your data alphabet.
  • Do not UPPER display-only columns if users expect preserved casing — use hidden helper column.
  • For case-insensitive COUNTIF some versions accept criteria without UPPER; test your Excel build.

Step-by-step: case-insensitive duplicate check

  • Step 1 — Email list in column A with mixed case.
  • Step 2 — Helper: =UPPER(TRIM(A2)).
  • Step 3 — Duplicate flag: =COUNTIF($B$2:B2, B2)>1 after filling UPPER helpers in B.
  • Step 4 — Or use [UNIQUE](/functions/unique/) on UPPER column in M365.
  • Step 5 — Store canonical UPPER keys for lookup tables; keep original for display.

UPPER vs LOWER vs PROPER

  • UPPER — ALL CAPS.
  • LOWER — all lowercase.
  • PROPER — capitalize first letter of each word.
  • Choose one canonical case for match keys; display layer can stay PROPER for names.

Worked examples to copy

  • Normalize SKU: =UPPER(A2).
  • Lookup key: =VLOOKUP(UPPER(E2), UPPER_key_table, 2, FALSE) with pre-built table.
  • State codes: =UPPER(B2) for two-letter validation.
  • Combine: =UPPER(TRIM(CLEAN(A2))) for import cleanup.

People also ask

  • UPPER change numbers? — No. Digits and punctuation stay the same.
  • UPPER for case-insensitive match? — Compare UPPER on both sides or use EXACT on UPPER pair.
  • UPPER vs Flash Fill? — UPPER is formula-driven and updates automatically.
  • Does UPPER work on entire column? — Yes. Fill down the formula.

Common errors

  • Only affects letters
  • Numbers and symbols unchanged

Use cases

  • Data standardization
  • Code formatting
  • Display formatting

Frequently asked questions

  • What characters does UPPER affect? UPPER converts only letters to uppercase. Numbers, symbols, and spaces remain unchanged. =UPPER("abc123!") returns "ABC123!".
  • How do I make only the first letter uppercase? Use PROPER for title case (first letter of each word). For just first letter: =UPPER(LEFT(A1,1))&LOWER(MID(A1,2,LEN(A1))).
  • Does UPPER work with international characters? Yes, UPPER handles accented characters: =UPPER("café") returns "CAFÉ". It works with most Unicode letters.
  • How do I compare text case-insensitively? Convert both to same case: =UPPER(A1)=UPPER(B1) or =LOWER(A1)=LOWER(B1). Or use EXACT for case-sensitive: =EXACT(A1,B1).
  • Can I uppercase only certain words? Use SUBSTITUTE with UPPER: =SUBSTITUTE(A1, "important", UPPER("important")) uppercases specific word. For complex rules, consider VBA or Power Query.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use UPPER

  • Data standardization — common Text scenario for UPPER.
  • Code formatting — common Text scenario for UPPER.
  • Display formatting — common Text scenario for UPPER.

UPPER in the Text category

  • Browse all Text functions at /categories/text/ for related formulas.
  • UPPER syntax: =UPPER(text)
  • text (required): The text to convert
  • Confirm UPPER arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm UPPER arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • LOWER (/functions/lower/): Converts text to lowercase.
  • PROPER (/functions/proper/): Capitalizes the first letter of each word in a text string.
  • TEXT (/functions/text-function/): Converts a value to text in a specified number format.

Errors to watch for

  • Only affects letters — review causes on linked error pages in the directory.
  • Numbers and symbols unchanged — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter UPPER on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

UPPER worked examples to copy

  • =UPPER("hello") — Convert to uppercase. Expected result: HELLO.
  • =UPPER(A1) — Uppercase cell content. Expected result: UPPERCASE TEXT.

UPPER reference summary for crawlers and offline review

  • UPPER belongs to the Text category in Excel. Converts text to uppercase.
  • Full syntax: =UPPER(text). Open /functions/upper/ for parameters, FAQs, and related pages.
  • Common mistakes: Only affects letters; Numbers and symbols unchanged
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.