PROPER converts text to title case: the first letter of each word becomes uppercase and every other letter lowercase. Any non-letter starts a new word, so spaces, hyphens, apostrophes and digits all trigger capitalization — great for names, surprising for McDonald or it's.
Returns text. The first letter after any non-letter is uppercased; all other letters are lowercased.
A word boundary is any non-letter. Measured live. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =PROPER(A2) | Alice Smith | Already proper, unchanged |
| =PROPER(C2) | New York | City to title case |
| =PROPER(A3) | Bob Jones | Uppercase name normalized |
| =PROPER(C5) | Chicago | Mixed case normalized |
| =PROPER("jOHN mCdonald") | John Mcdonald | Internal capitals lost |
| =PROPER("hello-world") | Hello-World | Hyphen boundary |
| =PROPER("it's a test") | It'S A Test | Apostrophe boundary trap |
| =PROPER("123 main st") | 123 Main St | Digit boundary |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to see title case and its boundary traps.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
PROPER is a core text function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
PROPER is one piece. The full course walks the toolkit end to end with live, measured examples.