Faster and easier than doing them one by one
Quick Way to Change Text in Excel Without a Formula – Excel Tutorials
When importing data into a spreadsheet, you may come across mixed case or words that contain only uppercase or lowercase letters. If you'd rather keep your textual data consistent, we'll show you a few ways to change case in Excel.
We'll walk you through three features you can use: the Flash Fill feature, a handy Office add-in, and a way to copy and paste between Microsoft Excel and Word. Use whichever method is easiest or works best for you.
Whether you're already using Excel formulas or not, there are three handy functions for modifying text. UPPER, LOWER, and PROPER let you modify your text with a simple formula.
