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 use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.