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.

Text to columns Text to columns is another handy function when you have data all crammed into one cell, and you need to split it into separate columns.