Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to convert text to proper case (title case) in Excel and Google Sheets
Excel & Google Sheets
=PROPER(A2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| header | header |
| john doe | smith |
| alice wonderland | carroll |
=PROPER(A2)→John Doe
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Select the cell where you want the converted text to appear.
- 2Enter the formula =PROPER(A2) in Excel or =PROPER(A2) in Google Sheets.
- 3Press Enter to see the text in proper case.
Tips
- Ensure your text is in a single cell or use an array formula for multiple cells.
- The PROPER function capitalizes the first letter of each word but may not handle certain exceptions like 'and', 'the', etc., correctly.
- Check your locale settings as they can affect how text is capitalized.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Does the PROPER function work with numbers?
No, the PROPER function only affects alphabetic characters.
Can I apply this to a range of cells?
Yes, by dragging the fill handle or using an array formula.
What if my text has special characters?
Special characters are ignored, and the function will capitalize letters around them.