How to insert a wildcard?

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")

countif formula

Lets us discuss another common wildcard: =COUNTIF(A2:A9,"?????")

This will count the cells with 5 alphabet strings:

Input values:

text

Dim Sub

Sub Word

Text5

Text4

Text5

Text

sub

Text

sub

new Sub

word

 

Results: 3

Reason:

Text5

Text4

Text5

five alphabet strings

Please find below some of the wildcard examples we generally use:

example wildcard usage