Discover How To Use Find And Replace To Find An Asterisk With This Excel Tutorial

Discover How To Use Find And Replace To Find An Asterisk With This Excel Tutorial
Page content

See all Microsoft Excel tips

This is because the * is seen as a wildcard character. What if you really want to search for an asterisk?

Strategy:

**

There are three wildcard characters that can be used in the Find and Replace dialog.

If you include an asterisk, Excel will search for any number of characters where the asterisk is located. “Wal*mart” will find “Wal*mart” but also “Walton Williams is smart”.

If you include a question mark, Excel will search for any one character. Searching for “?arl” will find both “Carl” and “Karl”. To really force Excel to search for an asterisk or a question mark, precede the asterisk by a tilde (~). When you search for “Wal~*mart”, Excel will only find “Wal*mart”, as shown in Fig. 784. If you search for “Who~?”, Excel will only find “Who?” and not “whom”.

Additional Details:

To change all of the multiplication formulas to division formulas, ask to change all ~* to /, as shown in Fig. 785.

Summary:

When you need to search for an actual question mark or an asterisk, precede the wildcard character with a tilde.

Commands Discussed:

Edit – Replace; Edit – Find

**

See all Microsoft Excel tips

Images

Fig. 784

Fig. 785