Convert Text to Proper Case

What it does

Excel has a =PROPER() function that capitalizes the first letter of each word, but using it means inserting a helper column, copying the formula down, then paste-as-values back over your original column, then deleting the helper. That's four steps with three places to mess up. The macro does it in place: select your range, run it, every text cell gets converted to Proper Case (first letter of each word capitalized, rest lowercased) in a single pass. Formula cells and non-text cells are left untouched.

Real-world example

Picture a registrar at a 1,200-student private K-12 school the week before classes start. She's importing the new student roster from the admissions system. The admissions system stores names exactly as the parent typed them on the application form. So the roster has gems like JOHN SMITH, priya sharma, EmIlY oRtIz, and a few all-caps grandparent names that look like they were typed with caps lock on by accident.

Before printing 1,200 ID-card mailing labels, she needs the names in consistent Title Case. Her current routine: insert a helper column next to the name column, type =PROPER(A2) in the first row, fill down 1,200 rows, copy the helper, Paste Special > Values onto the original, delete the helper. The hard part isn't the steps; it's that her helper-column muscle memory sometimes pastes the wrong direction and her first ten rows get overwritten with garbage.

With this macro she selects the student name column, runs the tool, and 1,200 names go from chaos to clean Title Case in about 3 seconds. The popup confirms how many cells got converted. She runs it on the parent name column, then the address column. Total elapsed: under a minute. Labels print clean.

On a 1,200-row student-name pass, expect about 4 minutes saved versus the helper-column routine. Per back-to-school season that's a small win, but the bigger one is that no row ever gets accidentally clobbered because the macro never touches a column other than your selection.

How to use

First time? See How to run our tools for the 30-second setup.

1. Select the range of text you want to convert.
2. Press Alt + F8 (Windows) or Option + F8 (Mac), pick ProperCaseText, click Run.
3. The macro converts every text cell in place. The popup reports how many cells were converted and how many formula cells were skipped.

FAQ

Does it handle names like "McDonald" or "O'Brien" correctly?

Honestly, no. The macro uses Excel's built-in Proper() function, which capitalizes the letter immediately after a space, hyphen, or apostrophe. So MCDONALD becomes Mcdonald (not McDonald), and O'BRIEN becomes O'Brien (correct). For Mc/Mac/O' surnames, plan to spot-check the result and fix the handful that need the second capital. There's no perfectly automatic fix because the rule is cultural, not syntactic.

Will it convert numbers or dates?

No. The macro only touches cells whose value is a text string. Numbers and dates are skipped. So if your column has Smith next to 2026-04-28, only the name cell gets converted; the date stays as is.

What about all-caps acronyms like USA, IRS, NYC?

These get lowercased by Proper. Send to USA becomes Send To Usa. If your column has acronyms you need to preserve, this macro is the wrong tool; run a Find/Replace afterward to restore the specific acronyms. We may add an "acronym preserve list" option in a future version if folks ask.

Will it skip formula cells?

Yes, formula cells are skipped. The popup tells you how many were skipped so you can investigate if the count is unexpected. If you want a formula's result converted, copy the formula column, paste as values to break the formula, then run the macro.

Can I undo it?

Yes, Ctrl/Cmd + Z right after running. Because the macro overwrites the original cell values, work on a copy of your file if you cannot afford a bad result. The macro runs entirely offline. Your data never leaves your machine.