Sometimes it's not possible to separate data yourself before putting it into an Excel spreadsheet. Often, the information from old data files gets lumped into a single cell. The same can happen if ...

Remove Text before or after a specific Character in Excel This post will show you how to remove the first or last few characters or certain position characters from the text in Microsoft Excel.

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

How to Put Quotations in a Cell in Excel. Microsoft Excel uses double quotation marks to signify text within formulas. When it sees these marks, it uses the text and discards the quotes.

Trying to make all of the text or words fit properly in your Excel spreadsheet? Learn how to make text fit in Excel with our tutorial.

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.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

You can wrap text in Excel in several ways to ensure that all the text in a cell is visible at once. You may also want to edit the cell height.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.