Tool 07

🔤 Change Text Case in Excel

Changes the capitalization of whole columns to Title Case, UPPERCASE, lowercase or Sentence case — without breaking names, company forms or state codes.

🔒 Works offline — your file never leaves your computer

What the text case fixer does

Before and after: text case

BeforeAfter
JOHN MCDONALDJohn McDonald
bank of americaBank of America
SUMMIT IT SERVICES LLCSummit IT Services LLC
boston, MABoston, MA
Real output of the tool with Title Case.
⬇ Download Tool — Free
or use it right here in your browser →
Single HTML file · opens in Chrome, Edge, Firefox or Safari · no installation, no sign-up

How to change text case in Excel in 3 steps

1
Download the toolClick the red button and save the file to your computer.
2
Open it in your web browserDouble-click the downloaded file. It opens in your browser — not in Excel. No installation, no account.
3
Choose your Excel file and save the cleaned copyClick "Run", check the before/after examples on screen, then save. Your original file stays untouched.

Before you start: limits and backup

Why capitalization goes wrong in Excel lists

When lists come from different sources, capitalization is all over the place: JOHN SMITH in one row, john smith in the next, John Smith in a third. In letters, labels and offers this looks careless.

Excel's PROPER() function helps only halfway — it turns McDonald into Mcdonald, LLC into Llc and NY into Ny. This tool knows these cases. It keeps company forms, common acronyms and state codes in capitals, handles Mc and O' names and writes small words like "of" and "and" in lowercase.

Choose the style, pick the columns (or leave all selected) and save the cleaned copy. Your original file stays unchanged and nothing leaves your computer.

Common questions about text case in Excel

How do I change uppercase names to Title Case in Excel?

Choose Title Case and the columns you want to change. JOHN MCDONALD becomes John McDonald and mary o'brien becomes Mary O'Brien. You can pick single columns or leave all text columns selected.

Why does Excel's PROPER() write Mcdonald and Llc?

PROPER() only capitalizes the first letter of every word. This tool keeps company forms such as LLC, acronyms such as IT and US state codes such as NY in capitals, handles Mc and O' names and writes small words like of and and in lowercase.

Does the tool change email addresses or numbers?

No. Email and web addresses are never changed, and numbers, dates and formulas are left alone. Only text cells are changed.

More free Excel cleanup tools

← View all tools