Text
PROPER Function in Excel
Capitalizes the first letter of each word in a text string.
Syntax
- =PROPER(text)
Arguments
- text (required): The text to convert
Examples
- =PROPER("john smith") - Convert to title case - Result: John Smith
- =PROPER(A1) - Title case cell content - Result: Title Case Text
Excel PROPER function documentation
- PROPER capitalizes the first letter in each word and lowercases all other letters.
- Syntax: =PROPER(text). Ideal for fixing ALL CAPS or sloppy name imports for display.
- Not ideal for match keys — use [UPPER](/functions/upper/) or [LOWER](/functions/lower/) for lookups.
- Related: [UPPER](/functions/upper/), [LOWER](/functions/lower/), [TRIM](/functions/trim/).
PROPER syntax and limitations
- PROPER lowercases the rest of each word — "McDonald" may become "Mcdonald" (undesired for some names).
- Apostrophe names like O'Brien may need manual correction after PROPER.
- Apply TRIM first: =PROPER(TRIM(A2)).
- For title case with exceptions, manual edits or Power Query may beat pure PROPER.
Step-by-step: fix imported customer names
- Step 1 — Names in A2:A500 as "JOHN SMITH" or "jane doe".
- Step 2 — Display column: =PROPER(TRIM(A2)).
- Step 3 — Review rows with Mc, Mac, O', and D' prefixes manually.
- Step 4 — Keep original raw column for audit; use PROPER column in reports.
- Step 5 — Do not PROPER before VLOOKUP keys unless partners also use PROPER keys.
PROPER vs UPPER vs LOWER
- PROPER — human-readable title case for names and addresses.
- UPPER/LOWER — machine-friendly normalized keys.
- Combine PROPER on display + LOWER helper on separate column for matching.
- Compare text cleanup: [TRIM](/functions/trim/) + PROPER is common CRM cleanup stack.
Worked examples to copy
- Name fix: =PROPER(A2).
- Full name: =PROPER(TRIM(B2&" "&C2)).
- City list: =PROPER(D2) after TRIM on ALL CAPS city imports.
- Sentence case single field: =PROPER(LOWER(A2)) when source is random case.
People also ask
- PROPER vs Title Case? — PROPER is Excel's built-in title case approximation.
- PROPER break McNames? — Yes sometimes — review Irish/Scottish prefixes manually.
- PROPER for addresses? — Good starting point; verify PO Box and state abbreviations.
- PROPER before VLOOKUP? — Only if lookup table uses same PROPER formatting.
Common errors
- Capitalizes after any non-letter
- May incorrectly capitalize (McDonald's → Mcdonald'S)
Use cases
- Name formatting
- Title formatting
- Data cleaning
Frequently asked questions
- How does PROPER determine word boundaries? PROPER capitalizes after any non-letter character, not just spaces. =PROPER("mary-jane") returns "Mary-Jane". This can cause issues with apostrophes: "o'brien" becomes "O'Brien" (correct) but "mcdonald's" becomes "Mcdonald'S" (incorrect).
- How do I handle names like McDonald or O'Brien? PROPER doesn't handle these well. Create exceptions list or use: =SUBSTITUTE(PROPER(A1), "Mcdonald", "McDonald"). For complex rules, consider VBA or Power Query.
- Does PROPER work with all caps input? Yes, PROPER first lowercases everything, then capitalizes first letters. =PROPER("JOHN SMITH") returns "John Smith".
- How do I capitalize only the first letter of a sentence? PROPER capitalizes every word. For sentence case: =UPPER(LEFT(A1,1))&LOWER(MID(A1,2,LEN(A1))) capitalizes only the first letter.
- Can PROPER handle international names? PROPER works with accented characters: =PROPER("josé garcía") returns "José García". However, language-specific rules (like Dutch "van" staying lowercase) aren't handled.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.
When to use PROPER
- Name formatting — common Text scenario for PROPER.
- Title formatting — common Text scenario for PROPER.
- Data cleaning — common Text scenario for PROPER.
PROPER in the Text category
- Browse all Text functions at /categories/text/ for related formulas.
- PROPER syntax: =PROPER(text)
- text (required): The text to convert
- Confirm PROPER arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
Formula checklist before you copy down
- Confirm PROPER arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
- If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
- Spot-check three known input rows manually against expected output.
Related Excel functions
- UPPER (/functions/upper/): Converts text to uppercase.
- LOWER (/functions/lower/): Converts text to lowercase.
- TEXT (/functions/text-function/): Converts a value to text in a specified number format.
Errors to watch for
- Capitalizes after any non-letter — review causes on linked error pages in the directory.
- May incorrectly capitalize (McDonald's → Mcdonald'S) — review causes on linked error pages in the directory.
Copy-paste audit workflow
- Enter PROPER on three test rows with known expected output documented on a QA tab.
- Fill down only after absolute references are locked on lookup tables and rate tables.
- Compare against manual calculation or a calculator for financial and statistical functions.
- Search this directory for comparison guides when choosing between similar functions in the same category.
PROPER worked examples to copy
- =PROPER("john smith") — Convert to title case. Expected result: John Smith.
- =PROPER(A1) — Title case cell content. Expected result: Title Case Text.
PROPER reference summary for crawlers and offline review
- PROPER belongs to the Text category in Excel. Capitalizes the first letter of each word in a text string.
- Full syntax: =PROPER(text). Open /functions/proper/ for parameters, FAQs, and related pages.
- Common mistakes: Capitalizes after any non-letter; May incorrectly capitalize (McDonald's → Mcdonald'S)
- Pair this function with comparison guides when another Excel formula might fit the same task better.
- Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.