Excel Guides

Searching for Wildcards in Excel

When you're working with data in Excel, there may be times when you want to find cells that contain specific information. For example, you may want to find all cells that contain the word "wildcard."

There are a few different ways that you can search for wildcards in Excel. One way is to use the Find feature. To do this, click the Home tab, then click the Find & Select button. In the Find & Select menu, click Find. In the Find what: field, enter the following:

[*]@[*]

This will find all cells that contain an "@" symbol. You can then narrow down your search by specifying additional criteria in the other fields in the Find and Replace dialog box.


Another way to search for wildcards in Excel is to use the Filter feature. To do this, click the Data tab, then click the Filter button.


In the column that you want to filter, click the arrow next to the column header, then click Text Filters. In the Text Filter menu, click Contains.... In the Contains Filter dialog box, enter the following in the Contains field:

[*]@[*]

This will find all cells that contain an "@" symbol.

You can also use wildcards when searching for data in Excel.

For example, if you want to find all cells that contain a number between 1 and 5, you would enter the following in the Contains field: [15].

If you want to find all cells that begin with "A", you would enter "A*" in the Contains field.

You can also use wildcards when searching for data in other programs, such as Microsoft Word or Microsoft PowerPoint.

For more information about using wildcards in Word, see Use wildcards with Find and Replace features in Word.. For more information about using wildcards in PowerPoint, see Use Wildcard Characters with Find and Replace Features.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.