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 Separate Text From Numbers in Excel. When you open a raw data file in Excel, the program doesn't always recognize the way in which the data is formatted, such as comma-delimited, tab ...

Perhaps Excel will create a built-in function to convert text to sentence case in the future, but until then, a formula will work. If you would like to follow along in building this formula, you can ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

How to Convert 5-Digit Julian Dates to Regular Dates in Excel. The Julian date format is a five digit number broken into two parts: a two-digit representation of the year followed by a three-digit ...

If Microsoft Excel does not recognize dates, then there is something wrong with the formatting. Use any of the methods mentioned here to format cells perfectly.