In this article we will learn to insert a wildcard in Excel.
What is a Wildcard? A wildcard is a special character that let's you perform "fuzzy" matching on text in your Excel formulas.
For example, this formula: =COUNTIF(A2:A9,"*sub")
Let start by creating data for the same. Now suppose we want to count the texts in column A which contains the word "sub", this can be easily done by using wildcard "*sub" in the countif formula: =COUNTIF(A2:A9,"*Sub")
Lets us discuss another common wildcard: =COUNTIF(A2:A9,"?????")
This will count the cells with 5 alphabet strings:
Please find below some of the wildcard examples we generally use: