How to / Text
How to capitalize the first letter in Excel
Use =PROPER(A3) to give every word a capital, as for names. For the first letter of the cell only, use UPPER on the first character and LOWER on the rest.
A capital at the start of every word
| A | B | C | |
|---|---|---|---|
| 1 | Name | ||
| 2 | Ana Silva | Ben Lee | |
| 3 | ben LEE | ||
| 4 | CHLOE o'neil |
In C2: =PROPER(A3) → Ben Lee
How it works
- PROPER makes the first letter of each word a capital and every other letter small.
- It works whatever the text looked like before: "ben LEE", "BEN LEE" and "ben lee" all become "Ben Lee".
Variations
Only the first letter of the cell
A B C 1 Name 2 Ana Silva Ben lee 3 ben LEE 4 CHLOE o'neil In C2:
=UPPER(LEFT(A3, 1))&LOWER(MID(A3, 2, LEN(A3)))→ Ben leeLEFT takes the first character and MID takes the rest. This is the one to use for sentences.
Everything in capitals
A B C 1 Name 2 Ana Silva BEN LEE 3 ben LEE 4 CHLOE o'neil In C2:
=UPPER(A3)→ BEN LEEEverything in small letters
A B C 1 Name 2 Ana Silva ben lee 3 ben LEE 4 CHLOE o'neil In C2:
=LOWER(A3)→ ben leeA name with an apostrophe
A B C 1 Name 2 Ana Silva Chloe O'Neil 3 ben LEE 4 CHLOE o'neil In C2:
=PROPER(A4)→ Chloe O'NeilPROPER starts a new capital after any character that is not a letter.
Watch out for
- Names PROPER gets wrong. It turns "McDonald" into "Mcdonald" and "van der Berg" into "Van Der Berg". Check names like these by hand.
- Letters after digits and apostrophes. Because a capital follows every non-letter, "it's" becomes "It'S" and "2nd" becomes "2Nd". For sentences, use the first-letter-only formula.
Doesn't work on your data? Paste your formula into the formula checker with a few rows of your sheet. It points at the part that fails and says why.
Functions used
- PROPER: Capitalises The First Letter Of Each Word.
- UPPER: Converts text to UPPERCASE.
- LOWER: Converts text to lowercase.
- LEFT: The first characters of a text value.
- MID: Characters from the middle of a text value.