
PROPER Function: Capitalize Names & Titles Correctly
Customer names imported from CRMs and databases rarely arrive in the right case — all caps, all lowercase, or randomly mixed. Excel’s PROPER function fixes the entire column in one formula, capitalising the first letter of every word and lowercasing everything else. This guide covers the full picture: when to use PROPER over UPPER and LOWER, its four known limitations (Mc/Mac prefixes, acronyms, apostrophes, and numbers), and the SUBSTITUTE workaround that fixes each one. You will also find the sentence case formula Excel is missing natively, the TRIM+CLEAN pipeline for dirty data, and eight practical examples from customer names through to mail-merge salutations.










