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.

Excel also enables you to enter a date in a cell without actually setting the cell's type to "Date." Dates stored in text cells can cause all sorts of problems, especially if you want to filter or ...

The purpose of the Convert Text to columns wizard is to separate the content of one excel cell into separate cells. You can set the delimiters that your data contain and set the column data format.

text from one or more cells into one cell—date cells with text cells in an Excel formula, you must first convert the referenced date cells to text; otherwise, you end up with an unexpected result.

Here’s how it works. First, select the column of cells that contains the raw data, then open the Data menu and choose Text To Columns. When you do, Excel launches the Convert Text To Columns Wizard.

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.