If your data includes inconsistent types, such as numbers mixed with text in the same column, this automatic step can cause ‘DataFormat.Error: We couldn’t convert to Number’.

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.