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

Learn how to easily set up your own search field in Excel to find and filter content within a table.

Learn about 10 Text functions in Excel with examples, including Find, Len, Left, Right, Mid, Substitute, Upper, Trim, Concatenate, and 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.

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

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

Find the data you need in an Excel sheet more easily with these functions.

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.

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