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

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

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

How to Find & Delete Multiple Instances in Excel. Deleting values in multiple cells is not a problem when the cells are continuous or located in a small spreadsheet. However, deleting cell values ...

PowerShell Pipeline Find Data in Excel Using PowerShell For those times when converting Excel files to .CSV just doesn't make sense. By Boe Prox 04/06/2018 ...

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.

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