Type the preferred capitalization into the Replace With text field. If you want to delete all instances where all caps appear, leave the Replace With text field blank. Check the "Match case" option.

Luckily, Excel offers handy formulas that allow you to convert text into upper case, lower case, title case, and even sentence case with minimal effort.

How to Find & Replace Text Parts in MS Excel. Manually finding and replacing parts of text can be exceedingly tedious for lengthy Excel spreadsheets. Luckily, Microsoft included a couple of useful ...

If you want to change the text case from lowercase to uppercase in Microsoft Excel, then this guide shows you five ways to do it.