Text
Convert to Title Case
Convert text to Title Case where the first letter of each word is capitalized. Perfect for formatting names, titles, and headings consistently.
Excel Formula
=PROPER(A2)Step-by-Step Explanation
1
PROPER capitalizes the first letter of each word
2
Converts all other letters to lowercase
3
Works with any text string
4
Example: "JOHN DOE" becomes "John Doe"
5
Note: Also capitalizes after apostrophes (e.g. O'Brien)
Example
| Original (A) | Title Case (B) |
|---|---|
| JOHN DOE | John Doe |
| hello world | Hello World |
| mAry jane | Mary Jane |
Result: =PROPER(A2) → John Doe
Common Variations
Uppercase
=UPPER(A2)ALL CAPS
Lowercase
=LOWER(A2)all lowercase
Sentence case
=UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2)))Only first letter capitalized
Need a Custom Version?
Use our AI generator to create a formula tailored to your specific data and requirements.
Try It with AI →