Formulas

How to Filter Text with Wildcards?

Pinterest LinkedIn Tumblr

In this tutorial, let’s see how to filter text with wildcards. Asterisk, question mark, and tilde are the three wildcard characters in Excel.

Suppose, you have a data set as shown below. So, how will you filter the text that has only wildcards.

Stick to the following steps.

filter text with wildcards

Step 1 – Select the cells to which you want to apply filter >> Data >> Sort and filter>>Filter.

How to Filter Text with Wildcards? 1

A dropdown arrow appears likes this.

How to Filter Text with Wildcards? 2

Step 2 – Click on the filter icon to apply the filter specifications.

How to Filter Text with Wildcards? 3

Step 3– Now, type R* to filter text that starts with R and has * in it. Click OK.

How to Filter Text with Wildcards? 4

That”s it. We are done.

How to Filter Text with Wildcards? 5

Follow us on YouTube for more interesting video tutorials.

Related Posts

Write A Comment