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.

Learn how to find and replace wildcard characters in Excel as normal text using tilde special characters. It is very easy to do so!

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 ...

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

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.

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.

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