Excel Tutorials
Fix inconsistent capitalization in a name or title column in seconds. This lesson uses the Event Planner workbook from Excel Foundations, free to download below.
Follow along in the same file used in the video. No email required.
PROPER capitalizes the first letter of every word in a cell and lowercases the rest, turning something like "jOHN smith" or "JANE DOE" into a clean "John Smith" or "Jane Doe."
It's most useful when you're cleaning up a list that came from somewhere else, a form submission, an import, or manual entry, where capitalization was never consistent to begin with.
Step-by-step, matching the video above.
Pick a cell next to the messy text you want to fix, not the messy cell itself.
Type =PROPER( then click the cell reference with the messy text, like =PROPER(A2).
Type the closing parenthesis and hit Enter. The corrected, properly capitalized version appears.
Drag the small square at the corner of the cell down to apply the same formula to every row in your list.
Select the new column, copy it, then Paste Special > Values over the same cells (or a new spot) to lock in the corrected text as plain values instead of a formula.
Once you've pasted the values, you can safely delete the original inconsistent column if you no longer need it.
Two closely related text functions worth knowing alongside PROPER, useful for different kinds of cleanup.
=UPPER(A2) converts every letter to capitals. Useful for codes, IDs or reference numbers that should always display in all caps.
=LOWER(A2) converts every letter to lowercase. Commonly used to standardize email addresses before checking for duplicates.
Each takes one text argument, references the messy cell, and produces a cleaned-up version you can then paste as values just like PROPER.
If you delete or edit the original messy-text cell before converting the PROPER formula to a value, the corrected cell breaks or goes blank.
PROPER doesn't know IBM should stay in all caps, it will turn it into "Ibm." Review acronym-heavy lists before trusting the output completely.
PROPER is a text function. Running it on a column of numbers or dates won't do anything useful and can produce unexpected results.
Formatting fixes shouldn't be a step you have to remember.
Free 14-day trial. No credit card required.
It capitalizes the first letter of each word in a cell and lowercases the rest, fixing inconsistent capitalization.
Copy the PROPER formula results, then use Paste Special > Values to convert them into permanent text before removing the original messy column.
PROPER capitalizes each word's first letter. UPPER makes everything capitals. LOWER makes everything lowercase.
No. PROPER treats every word the same way, so an acronym like IBM becomes Ibm. Review acronym-heavy data before trusting the output.
Yes. Write the formula in the first row, then copy it down to apply it to every row in the column.
The PROPER formula was still referencing the deleted cells. Convert the formulas to values with Paste Special before removing the original data.
Yes, it's common to wrap PROPER around TRIM, like =PROPER(TRIM(A2)), to fix capitalization and remove extra spaces in one formula.
No. PROPER produces a new value in whatever cell you write the formula in, it doesn't alter the original messy cell unless you later paste the result as values over it.
Every business starts with a spreadsheet. Updoot is where you scale past it, data stays consistent automatically.
Start Your Free Trial →