Learn about 10 Text functions in Excel with examples, including Find, Len, Left, Right, Mid, Substitute, Upper, Trim, Concatenate, and Text.

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

VLOOKUP and Search are two functions that Excel uses to search for text. VLOOKUP finds data in a column and returns the contents of an adjacent cell.

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

How to Find Cells With Strikethrough in Excel. For a business leader, Microsoft Excel 2010 can be an invaluable tool for monitoring inventory, recording customer information or keeping track of ...

Learn how to Find and Remove hyperlinks in Excel easily, for all texts or for specific text only. Use the Format section of Microsoft Excel to do it.

You can include both a formula and text in the same cell in Excel.

Filters are great tools, but you can't remove specific items from the results. When you need to do this, try Find All in Excel instead.

Text wrapping isn't just for word processors. You can wrap text in spreadsheets too. Here's how to wrap text in Microsoft Excel using two different methods.

When you think of double quotation marks, you probably remember your English lessons in school. However, in Microsoft Excel, ...