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.

If you want to apply a formula to an entire column in Excel, use the Fill down option, or use other great methods from this guide.

How to use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.