# UPPER function in Excel

> UPPER converts every letter in a text string to capitals.

Source: https://spreadsheetpractice.com/functions/upper · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** UPPER converts every letter in a text string to capitals.
- **Syntax:** `=UPPER(text)`
- **Most common use:** `=UPPER(A2)` returns MN (A state code in capitals)
- **Available in:** Every current version
- **Category:** [Text functions](https://spreadsheetpractice.com/functions/category/text)
- **Returns:** The same text in uppercase. Digits and symbols don't change.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

UPPER converts every letter in a text string to capitals. Use it to standardize codes that should always be uppercase, such as state abbreviations, SKUs, airport codes and postcodes.

## Syntax

`=UPPER(text)`

| Argument | Required? | What it is |
|---|---|---|
| `text` | Required | The text or cell to convert. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=UPPER(A2)` | MN | A state code in capitals |
| D3 | `=UPPER(B3)` | GDT-RED-M | Dashes and letters together: only the letters change |
| D4 | `=UPPER(LEFT(C4,FIND(" ",C4)-1))` | M1 | The first part of a UK postcode, capitalized |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | State | SKU | Postcode | Result |
| 2 | mn | wdg-blu-l | sw1a 1aa | MN |
| 3 | Ca | gdt-red-m | ec1v 9hq | GDT-RED-M |
| 4 | tx | gzm-grn-s | m1 1ae | M1 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Expecting UPPER to fix lookups | Excel lookups ignore case, so uppercase codes aren't needed for VLOOKUP or XLOOKUP to match. Convert for consistency, and use EXACT when case truly matters. |
| Numbers turn into text | UPPER on a number returns it as text, which SUM skips. Apply it only to text columns. |

## Tips

- Nest TRIM inside to clean spacing at the same time: =UPPER(TRIM(A2)).

## Related functions

- [LOWER](https://spreadsheetpractice.com/functions/lower): LOWER converts every letter in a text string to lowercase and leaves numbers and symbols alone.
- [PROPER](https://spreadsheetpractice.com/functions/proper): PROPER capitalizes the first letter of each word and lowercases the rest.
- [EXACT](https://spreadsheetpractice.com/functions/exact): EXACT compares two text values and returns TRUE only if they match exactly, including upper and lower case.

## Questions

### How do I make all text uppercase in Excel?

Use =UPPER(A2) in a helper column, fill it down, then copy and paste the results as values over the original.

### Does UPPER change numbers or symbols?

No. Only letters change. Digits, punctuation and spaces stay as they were.

## Practice

A graded UPPER exercise ("Standardize SKUs") is on [the UPPER page](https://spreadsheetpractice.com/functions/upper). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
