Sometimes you want to find an asterisk or question mark within your text, but Excel interprets those as wildcards. Here’s how to find those specific characters in your search.
Tag Archives | FIND
Let’s say you have an extensive list that includes a number of hyperlinks. Here is a method to locate, count, highlight and even delete those hyperlinks. We’ll use the FIND option and also a Visible Cells Only shortcut.
The Find & Replace commands in Excel, as well as other software applications, seems quite obvious in its use – to locate certain items in your worksheet and replace those items with an alternative. But Find & Replace can do quite a bit more. Let’s take a look at these features in Excel…..
Here is a way to filter a list by the font of certain entries…..
Here’s how we can use MID, FIND, and IFERROR to extract phone and fax numbers from a list in Excel…..
Here is the process I used to build a complicated formula using 7 different functions in Excel…..