← Back to level 1
Level 1Next
PROPER
A easy text formula for turning words into title case style capitalization.
Syntax
=PROPER(...)Step-by-step explanation
- 1Understand the job that PROPER solves before you type the formula.
- 2Build or select the cells and ranges that PROPER needs before typing it.
- 3Check the output and refine the range or criteria if needed.
Common mistakes
Using it on codes that should stay uppercase
Expecting it to handle every punctuation rule perfectly
Forgetting that small words may still change
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=PROPER(A1:B2)
Result
42
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =PROPER(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 42.
Practice area
Use PROPER when names or headings should start each word with a capital letter.
Match against the syntax block above.