Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
PROPER
PROPER converts a string to title case by capitalizing the initial letter of every word and making remaining letters lowercase. Use it to format names, headings, or address fields that may have been entered in all caps, all lowercase, or mixed case.
Excel
=PROPER(A2)Google Sheets
=PROPER(A2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| RawName |
| ALICE SMITH |
| bob jones |
| CAROL ANN BROWN |
| david O'BRIEN |
=PROPER(A2)→Alice Smith
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
How it works
- 1Reference the cell containing the text to be title-cased.
- 2Enter =PROPER(text) to apply title-case formatting.
- 3Be aware that PROPER capitalizes letters after any non-letter character, which can affect hyphenated names or abbreviations.
Need a version for your data?
Try: “Convert customer names that were entered in all caps to proper title case”