UPPER converts any text value to all capital letters, leaving numbers and punctuation unchanged. It is a simple Text function that helps standardise names, codes, and labels for consistent reporting.
=UPPER(text)What does UPPER do?
The UPPER function in Excel changes text to ALL CAPITALS. You give it a piece of text or a cell reference, and it returns the same text with every lowercase letter converted to uppercase. Numbers, spaces, and punctuation stay exactly as they are.
Why does this matter? Inconsistent capitalisation makes data look messy and can break lookups, sorting, and matching. If one list has "north" and another has "North", Excel treats them as different values. UPPER lets you standardise text so comparisons and reports behave predictably.
Imagine you receive a customer list where names and region codes are typed in mixed case. Before you build a pivot table or match records, you can add a helper column with =UPPER(A2) to make everything uniform. The original data stays untouched, and your analysis becomes reliable.
When to use UPPER
- Standardising country or region codes before matching lists.
- Converting product SKUs or reference codes to a consistent format.
- Cleaning imported data where names and labels have random capitalisation.
- Preparing headers or labels for reports that require all caps.
- Creating uppercase keys for VLOOKUP or XLOOKUP comparisons.
- Formatting email addresses or usernames for display in a fixed style.
UPPER syntax
=UPPER(text)| Argument | Required? | What to enter |
|---|---|---|
text | Required | The text you want to convert to capitals. It can be a cell reference like A2, a literal string like "hello", or a formula that returns text. |
What it returns: A text string with all lowercase letters converted to uppercase. Numbers, symbols, and spaces are returned unchanged.
UPPER examples
1 Convert a single word to capitals
This example shows the simplest use of UPPER. The goal is to turn the word in cell A2 into all capitals. The formula =UPPER(A2) reads the text in A2 and returns it with every letter uppercased. Because A2 contains "excel", the result is "EXCEL". Numbers and punctuation would stay the same.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Word | |||
| 2 | excel | EXCEL | ||
| 3 | training | |||
| 4 | report | |||
| 5 | budget | |||
| 6 | summary | |||
| 7 |
2 Standardise region codes in a sales table
Here the region names are typed in mixed case. The goal is to produce a clean uppercase version for reporting. The formula =UPPER(A2) converts "North" to "NORTH". Each row can use the same formula copied down. The original region column remains unchanged for reference.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Sales | |||
| 2 | North | 1200 | NORTH | ||
| 3 | south | 950 | |||
| 4 | East | 1100 | |||
| 5 | west | 800 | |||
| 6 |
3 Create uppercase product SKUs
Product codes often need a fixed uppercase format. The goal is to convert the SKU in A2 to capitals. The formula =UPPER(A2) changes "ab-102" to "AB-102". The hyphen and digits are unaffected. This makes the code easier to scan and match against other systems.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | SKU | Product | Price | |||
| 2 | ab-102 | Notebook | 4.5 | AB-102 | ||
| 3 | cd-205 | Pen | 1.2 | |||
| 4 | ef-310 | Folder | 2.8 | |||
| 5 | gh-415 | Stapler | 6 | |||
| 6 |
4 Clean customer names for a mailing list
Customer names are often entered with inconsistent capitalisation. The goal is to produce an uppercase version for a formal mailing label. The formula =UPPER(A2) converts "john smith" to "JOHN SMITH". Spaces are preserved. Copy the formula down to clean the whole list.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Customer | City | Order Date | |||
| 2 | john smith | London | 2024-01-15 | JOHN SMITH | ||
| 3 | mary jones | manchester | 2024-02-03 | |||
| 4 | alex brown | Leeds | 2024-02-20 | |||
| 5 | sara lee | bristol | 2024-03-05 | |||
| 6 |
5 Build an uppercase lookup key
When two tables use different capitalisation, lookups can fail. The goal is to create a standard uppercase key from the email in A2. The formula =UPPER(A2) turns "Alice@Example.com" into "ALICE@EXAMPLE.COM". You can then use this key with VLOOKUP or XLOOKUP against another uppercase list. This avoids mismatches caused by case differences.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Department | Start Date | ||||
| 2 | Alice@Example.com | Finance | 2023-06-01 | ALICE@EXAMPLE.COM | ||
| 3 | bob@example.com | HR | 2023-07-15 | |||
| 4 | Carol@Example.com | IT | 2023-08-20 | |||
| 5 | dave@example.com | Sales | 2023-09-10 | |||
| 6 |
Common UPPER errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | The text argument refers to a cell that contains an error value, or the formula is used in a way that Excel cannot interpret as text. | Check that the referenced cell does not contain an error. If needed, wrap the reference with IFERROR or correct the source data. |
| #NAME? | The function name is misspelled, for example =UPPER written as =UPPPER. | Type the function name correctly as UPPER. |
| #N/A | This is not caused by UPPER itself, but by a lookup that uses the UPPER result and cannot find a match. | Verify that both lookup lists are converted with UPPER and that the values truly match after conversion. |
| Wrong result (no change) | The cell contains a number or a formula that returns a number, so there are no lowercase letters to convert. | UPPER only changes letters. If you need to format numbers, use number formatting instead. |
Tips for using UPPER
- Use UPPER on a helper column rather than overwriting original data, so you keep a record of the source.
- Combine UPPER with TRIM to remove extra spaces before converting:
=UPPER(TRIM(A2)). - UPPER does not change the underlying value in the source cell; it returns a new text string.
- To convert text to proper case instead, use PROPER; for lowercase, use LOWER.
- When matching text, remember that UPPER makes comparisons case-insensitive only if both sides are converted.
- You can nest UPPER inside other functions, such as
=VLOOKUP(UPPER(A2), range, 2, FALSE).
Frequently asked questions
Does UPPER change numbers or dates?
No. UPPER only affects letters. Numbers, dates, and punctuation are returned unchanged.
Can I use UPPER on a whole column at once?
UPPER works on one text value at a time. To apply it to a column, enter the formula in the first cell and copy it down, or use it inside an array formula in newer Excel versions.
Is UPPER case-sensitive?
UPPER converts all letters to uppercase, so the result is always uppercase regardless of the original case.
What is the difference between UPPER and PROPER?
UPPER makes all letters uppercase, while PROPER capitalises the first letter of each word and makes the rest lowercase.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. UPPER reference