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

ABC
1Name
2 Ana Silva Ben Lee
3ben LEE
4CHLOE o'neil

In C2: =PROPER(A3) → Ben Lee

How it works

  1. PROPER makes the first letter of each word a capital and every other letter small.
  2. It works whatever the text looked like before: "ben LEE", "BEN LEE" and "ben lee" all become "Ben Lee".

Variations

  1. Only the first letter of the cell

    ABC
    1Name
    2 Ana Silva Ben lee
    3ben LEE
    4CHLOE o'neil

    In C2: =UPPER(LEFT(A3, 1))&LOWER(MID(A3, 2, LEN(A3))) → Ben lee

    LEFT takes the first character and MID takes the rest. This is the one to use for sentences.

  2. Everything in capitals

    ABC
    1Name
    2 Ana Silva BEN LEE
    3ben LEE
    4CHLOE o'neil

    In C2: =UPPER(A3) → BEN LEE

  3. Everything in small letters

    ABC
    1Name
    2 Ana Silva ben lee
    3ben LEE
    4CHLOE o'neil

    In C2: =LOWER(A3) → ben lee

  4. A name with an apostrophe

    ABC
    1Name
    2 Ana Silva Chloe O'Neil
    3ben LEE
    4CHLOE o'neil

    In C2: =PROPER(A4) → Chloe O'Neil

    PROPER starts a new capital after any character that is not a letter.

Watch out for

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

Practise it

Related