Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

Overview Functions like INDEX MATCH, SUMIF, and XNPV allow professionals to work smarter, not harder, especially when handling large or complex data sets.Using ...

Wrapping Text in Excel In some cases, you may have too much text in an Excel cell to fit on one line. In this case, you may want the text to wrap onto another line automatically.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.

How to Add Longer Text Into Excel Spreadsheets. When you enter longer text than will fit in a normal Excel cell, the excess text either carries over into the next blank cell or is truncated by ...

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.

In this month’s column, find out how to change text strings to sentence case in Excel.