In this tutorial we are going to see how we can use nested SUBSTITUTE functions, along with TRIM, RIGHT, FIND and LEN functions to convert a messy list of phone numbers into a neatly formatted group.
Tag Archives | FIND
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.
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…..