# PROPER function in Excel

> PROPER capitalizes the first letter of each word and lowercases the rest.

Source: https://spreadsheetpractice.com/functions/proper · 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:** PROPER capitalizes the first letter of each word and lowercases the rest.
- **Syntax:** `=PROPER(text)`
- **Most common use:** `=PROPER(A2)` returns Maya Chen (An all-caps name in name case)
- **Available in:** Every current version
- **Category:** [Text functions](https://spreadsheetpractice.com/functions/category/text)
- **Returns:** Text with the first letter of each word capitalized.

## What it does

PROPER capitalizes the first letter of each word and lowercases the rest. It cleans up names, cities and titles typed in all caps or all lowercase, though it needs help with names like McDonald and small words like "of".

## Syntax

`=PROPER(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 | `=PROPER(A2)` | Maya Chen | An all-caps name in name case |
| D3 | `=PROPER(B3)` | New York | A city in title case |
| D4 | `=PROPER(C4)` | Head Of Sales | Small words get a capital too: "Of" |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Name | City | Title | Result |
| 2 | MAYA CHEN | st. paul | vp, finance | Maya Chen |
| 3 | raj patel | NEW YORK | sales lead | New York |
| 4 | liam o'brien | eden prairie | head of SALES | Head Of Sales |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Mc and Mac names | PROPER turns MCDONALD into Mcdonald. Fix exceptions afterward with SUBSTITUTE, or by hand. |
| Small words capitalized | "head of sales" becomes "Head Of Sales". Lowercase them again with SUBSTITUTE: =SUBSTITUTE(PROPER(A2)," Of "," of "). |
| Acronyms lose their capitals | PROPER turns "IBM partner" into "Ibm Partner". Keep acronyms in their own column or restore them with SUBSTITUTE. |

## Tips

- Clean spacing and case in one step with =PROPER(TRIM(A2)).
- PROPER also capitalizes after an apostrophe or hyphen, so o'brien-smith becomes O'Brien-Smith.

## Related functions

- [UPPER](https://spreadsheetpractice.com/functions/upper): UPPER converts every letter in a text string to capitals.
- [LOWER](https://spreadsheetpractice.com/functions/lower): LOWER converts every letter in a text string to lowercase and leaves numbers and symbols alone.
- [TRIM](https://spreadsheetpractice.com/functions/trim): TRIM removes spaces from the start and end of text and shrinks runs of spaces between words to one.

## Questions

### How do I capitalize the first letter of each word in Excel?

Use =PROPER(A2). It capitalizes every word and lowercases the rest of each word.

### How do I capitalize only the first letter of a sentence?

Combine UPPER, LOWER, LEFT and MID: =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,999)).

## Practice

A graded PROPER exercise ("Clean names") is on [the PROPER page](https://spreadsheetpractice.com/functions/proper). It is checked instantly, then re-checked on changed data.

Lessons that use PROPER:

- [Lesson 20: Cleaning messy data](https://spreadsheetpractice.com/learn/cleaning-messy-data) (Pro)

---

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