PROPER capitalizes every word; sometimes you want only the first letter capitalized, like a sentence. Combine UPPER on the first character with LOWER on the rest.
The example
A shouty cell turned into a clean sentence.
| A | B | |
|---|---|---|
| 1 | Raw | Sentence case |
| 2 | the QUICK brown fox | The quick brown fox |
The formula
First letter up, the rest down:
How it works
Two halves, cased differently:
LEFT(A2,1)is the first character;UPPERcapitalizes it.MID(A2, 2, LEN(A2))is everything from the 2nd character on;LOWERmakes it lowercase.- Concatenate the two with
&for sentence case. - For Title Case instead (every word), use the built-in
PROPER(A2).
Multiple sentences? This caps only the very first letter. To capitalize after each period you’d need a more complex formula or a small helper — but for headlines, labels, and single sentences this is exactly right.
Try it: interactive demo
Type text; see sentence case.
Variations
Title case
Every word:
All caps / lower
Simple:
Trim first
Clean leading spaces:
Pitfalls & errors
Only the first letter. This doesn’t capitalize after periods — it’s for a single sentence or label.
Leading spaces. A space as the first character gets “capitalized” (no effect) and the real first letter stays lower. TRIM first if needed.
MID length. Using LEN(A2) as the MID length safely grabs the whole remainder.
Practice workbook
Frequently asked questions
How do I capitalize only the first letter in Excel?
How is that different from PROPER?
How do I capitalize after every period?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class