Excel UPPER Function: Syntax, Examples and Tips

Part of the free Module 5: Excel Formulas and Functions · Function 95 of 105 · Full Excel course

The Excel UPPER function converts every letter in a text string to upper case and returns the result as text. Digits, punctuation and spaces are unchanged. It is used to standardise codes, country abbreviations, headings and identifiers so that entries typed in different cases match, sort together and export consistently to other systems.

Table of Contents

Syntax

=UPPER(text)

Arguments

Argument	Required / Optional	Meaning
text	Required	The text string, or a reference to a cell containing text, that you want converted to upper case.

How UPPER works

UPPER replaces each letter with its upper-case form according to Unicode rules, so accented and non-Latin letters are handled: =UPPER("café") returns CAFÉ and Greek or Cyrillic text is converted correctly. Numbers passed to UPPER come back as text, so =UPPER(123) returns the text “123”. UPPER does not alter the source cell; it produces a new value where the formula sits, and you copy and paste as values if you want to overwrite the originals.

Step-by-step example: standardise product codes

Column A contains SKU codes entered by several people, such as ab-1001, Ab-1001 and AB-1001, which should all be the same item.
In B2 enter =UPPER(TRIM(A2)). TRIM removes stray spaces and UPPER standardises the case, returning AB-1001.
Fill the formula down the column.
Copy column B, paste as values over column A and delete column B. Remove Duplicates and COUNTIF now treat the three entries as one code.

Practical use cases

1. Country and currency codes

=UPPER(LEFT(A2,3))

Takes the first three letters and forces upper case, turning “usd” or “Usd” into USD.

2. Validation rule that requires capitals

=EXACT(A2,UPPER(A2))

Used as a custom Data Validation formula, this rejects any entry containing lower-case letters.

3. Initials from a name

=UPPER(LEFT(A2,1)&MID(A2,FIND(" ",A2)+1,1))

4. Consistent headings in a report

=UPPER(TEXT(A2,"mmmm yyyy"))

Produces a heading such as SEPTEMBER 2026 from a date cell.

5. Case-insensitive key for exports

=UPPER(A2)&"|"&UPPER(B2)

Systems that compare keys case-sensitively receive a single consistent form.

Common mistakes and tips

Applying UPPER to numbers or dates: they become text and stop working in arithmetic. Use UPPER only on genuine text or on TEXT output.
Expecting the source to change: UPPER is a formula. Paste as values to replace the originals, or use Flash Fill (Ctrl+E) for a one-off conversion.
Whole ranges: in Excel 365 =UPPER(A2:A100) spills; in Excel 2019 and earlier fill the formula down.
German sharp s and similar letters: ß has no single upper-case form in older Unicode rules and is left unchanged.
Not needed for lookups: VLOOKUP, MATCH and COUNTIF ignore case already, so UPPER is for consistency and exports rather than for matching inside Excel.

UPPER compared with LOWER, PROPER and Flash Fill

UPPER and LOWER are unconditional conversions in opposite directions; PROPER is rule-based and capitalises the first letter of each word. Choose UPPER for codes, abbreviations and headings, LOWER for email addresses and URLs, and PROPER for personal names and titles. Excel has no keyboard shortcut for changing case, unlike Word’s Shift+F3, so these functions or Flash Fill are the only options in the grid. Flash Fill creates static values and is quick for a single clean-up; the functions recalculate automatically and belong in templates and dashboards that receive new data regularly. Power Query offers Format, UPPERCASE for repeated imports and keeps the transformation outside the worksheet.