Using wildcards (asterisk, tilde, and question mark)

- In Excel, we sometimes need to use what are called…wildcard characters: a question mark or an asterisk.…Sometimes you'll need to use them…with the Find & Select feature,…that's a feature found on the…HOME tab, the far right button.…Or possibly when using a filter,…or possibly when using any of the different…COUNTIF function variations.…There are six different functions ending in the letters IF,…COUNTIFs, SUMIFs, etc.…So let's explore some of these.…First of all, in Column A, we've got some Part numbers.…

In a real life situation we probably would have…other columns adjacent to it that are related,…but we need to isolate or view for the moment…just those part numbers where H is the third character,…as in the first two examples.…So selecting Column A, and making sure the filter is active,…if it's not, go to the DATA tab, choose Filter.…I've got the filter in place here.…Two ways to approach this:…we could go to Text Filters,…and choose Begins with.…Now, I don't know what the first character is…or do I care, nor the second character.…