← Back to Blog

Excel Formula to Capitalize First Letter Only (3 Methods)

Excel has no single built-in function for "sentence case" (first letter only capitalized), but you can achieve it with a combination of text functions.

Method 1: PROPER — Capitalizes Every Word

=PROPER(A2)

Note: PROPER capitalizes the first letter of every word. "hello world" → "Hello World". Great for names, but not for sentences.

Method 2: Capitalize Only the First Letter of the Entire String

=UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2)-1))

Breakdown:

  • UPPER(LEFT(A2,1)) — takes the first character and uppercases it
  • LOWER(MID(A2,2,LEN(A2)-1)) — lowercases everything from the second character onward

Example: "hello world" → "Hello world"

Method 3: Capitalize Each Word's First Letter (PROPER Alternative)

PROPER is the clean option for names. To fix "mcdonald" or "o'brien" type edge cases, combine with SUBSTITUTE:

=SUBSTITUTE(PROPER(A2),"'S","'s")

Capitalize First Letter After a Space (First Word Only, Custom)

If you only want to capitalize the very first word and leave the rest unchanged:

=UPPER(LEFT(TRIM(A2),1))&MID(TRIM(A2),2,LEN(TRIM(A2)))

FAQ

What is the Excel formula to capitalize only the first letter?

=UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2)-1))

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

Use =PROPER(A2). It capitalizes the first letter of every word.

Does Excel have a sentence case function?

No built-in sentence case function exists. Use =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2)-1)) instead.

Need more text manipulation? Try our Split Text Tool or read about extracting last names from full names.