PROPER Function Generator
PROPER converts text to title case — first letter of each word capitalized, the rest lowercase. Common for cleaning up ALL-CAPS data or inconsistent name entries.
Syntax
=PROPER(text)Try it — generate a PROPER formula
Examples
Fix all-caps names
=PROPER(A2)"JOHN SMITH" becomes "John Smith".
Clean then title-case
=PROPER(TRIM(A2))Trim spaces, then title case.
Address line
=PROPER(A2)"123 main street" becomes "123 Main Street".
Tips
- ✓PROPER capitalizes after any non-letter, so "o'brien" becomes "O'Brien" (correct) but "mcdonald" becomes "Mcdonald" (often wrong). Fix edge cases with SUBSTITUTE.
- ✓Good for user-submitted forms where case is unpredictable.
Related Formulas
UPPER / LOWER
UPPER converts text to uppercase; LOWER converts to lowercase. Useful for normal...
TRIM
TRIM removes leading and trailing spaces and collapses multiple internal spaces ...
SUBSTITUTE
SUBSTITUTE replaces occurrences of a specific text inside a string. Lets you tar...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free