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.

SEE: 83 Excel tips every user should master (TechRepublic) In this Microsoft Excel tutorial, I’ll show you four easy ways to convert numbers stored as text to real numbers.