How to Use PROPER in Excel
Capitalises the first letter of every word — fixes SHOUTED or all-lowercase names from raw imports.
What is PROPER in Microsoft Excel?
PROPER converts text to Title Case by uppercasing the first letter of each word and lowercasing the rest. It is the standard fix for names, cities and product titles that arrive in ALL CAPS from a legacy system. It does not understand exceptions, so acronyms need a manual follow-up.
Formula Syntax
Arguments Breakdown
| Argument | Requirement | Purpose & Details |
|---|---|---|
| text | Required | The text to convert to title case. |
When to Use PROPER (Real-World Business Scenarios)
- 1
Cleaning a customer or employee name column imported in uppercase.
- 2
Standardising city and state names before a pivot table groups them.
- 3
Formatting product titles for a customer-facing report.
Step-by-Step Practical Business Example
Suppose you have the following dataset in Excel cells A1:D4:
| Raw | Proper |
|---|---|
| RAHUL SHARMA | Rahul Sharma |
| pooja verma | Pooja Verma |
| AMAN PATEL | Aman Patel |
How it works: Uppercases the R and the S and lowercases the remaining letters, converting the shouted input into a readable name.
Common Errors & How to Fix Them
Why it happens: PROPER lowercases every letter after the first in each word.
Fix: Patch them afterwards: =SUBSTITUTE(PROPER(A2),"Gst","GST").
Why it happens: PROPER treats the letter after an apostrophe as a new word, so O'BRIEN becomes O'Brien which is usually correct, but Mcdonald becomes Mcdonald.
Fix: Fix known exceptions with a small lookup table and IFERROR.
Try PROPER Live in Your Browser
No need to launch desktop Excel. Practice formulas with real-time feedback in our HyperFormula sandbox.
Frequently Asked Questions (PROPER)
What does the PROPER formula do in Excel?
PROPER converts text to Title Case by uppercasing the first letter of each word and lowercasing the rest. It is the standard fix for names, cities and product titles that arrive in ALL CAPS from a legacy system. It does not understand exceptions, so acronyms need a manual follow-up.
What is the syntax for PROPER?
What are common mistakes when using PROPER?
Acronyms look wrong: PROPER lowercases every letter after the first in each word. (Patch them afterwards: =SUBSTITUTE(PROPER(A2),"Gst","GST").) Apostrophe names break: PROPER treats the letter after an apostrophe as a new word, so O'BRIEN becomes O'Brien which is usually correct, but Mcdonald becomes Mcdonald. (Fix known exceptions with a small lookup table and IFERROR.)
Related Excel Formulas
Keep building your formula toolkit with these text functions.
- TEXTJOINJoins a whole range into one string with a delimiter you choose — the clean way to build comma-separated lists.
- TRIMRemoves leading, trailing and repeated spaces — the first fix for lookups that mysteriously return #N/A.
- SUBSTITUTEReplaces specific text inside a string — clean currency symbols, remove units or swap separators in bulk.
- LEFTExtracts the first characters of a string — pull a prefix, area code or year out of a longer code.
- LENCounts the characters in a cell, including spaces — the quickest way to catch invisible trailing whitespace.
- TEXTSPLITSplits one cell into many by a delimiter and spills the pieces into neighbouring cells — no Text to Columns needed.
Master PROPER in Basic Excel
Learn PROPER along with our formula library, practice files, and verifiable certificates in our complete curriculum.