Let's face it—if you're automating your data workflow with formulas, you shouldn’t be manually rewriting text just to change the case. Luckily, Excel ... in all caps, some in all lowercase.