🔤 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.
What the text case fixer does
- Four styles: Title Case, UPPERCASE, lowercase and Sentence case
- Title Case gets names right: JOHN MCDONALD → John McDonald, mary o'brien → Mary O'Brien
- Keeps LLC, Inc., IT and US state codes like NY in capitals, and small words like "of" and "and" in lowercase
- E-mail and web addresses are never changed
- Choose which columns to change — or all text columns at once
Before and after: text case
| Before | After |
|---|---|
| JOHN MCDONALD | John McDonald |
| bank of america | Bank of America |
| SUMMIT IT SERVICES LLC | Summit IT Services LLC |
| boston, MA | Boston, MA |
How to change text case in Excel in 3 steps
Before you start: limits and backup
- Always keep a copy of your original file as a backup and check the cleaned copy before you use it.
- Numbers, dates and formulas are never changed — only text cells.
- Reads .xlsx, .xls and .csv files and saves the result as a new .xlsx file.
- Only the first worksheet is cleaned. Other worksheets and title rows above your table are kept unchanged.
- Values, dates and number formats are kept. Cell colors and fonts are not carried over to the cleaned copy.
- The tools are provided free of charge and "as is". We have built and tested them with great care, but we cannot guarantee that every entry is recognized or changed correctly. As far as permitted by law, we accept no liability for results or any damage arising from their use. See Legal Notice & Disclaimer.
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
Clean Whitespace
Remove extra and invisible spaces
Format US Addresses
USPS-style street, city, state, ZIP
Address List Optimizer
US phone numbers, addresses and duplicates