Excel Wildcards

Explanation

Excel wildcards can be used to replace any character in Excel and allow the user to perform advanced searches and partial matching.

There are two wildcards in Excel:

? (Question Mark) – Replaces one character

* (Asterisk) – Replaces between 0 to any amount of characters.

In addition to these two signs, we can use the ~ (tilde) character when we want to escape these explicit characters.  

Example

For this example, we will use the COUNTIF function to count the number of words that meet certain wildcard criteria!

Practice Excel Wildcards

Now, time to put our knowledge in Excel Wildcards into practice! 🙂

Using SUMIF with Excel Wildcards

Now, let’s use the SUMIF function combined with the power of Excel Wildcards! 🙂

Counting using Excel Wildcards

Use the COUNTIF function to solve this one!