Finding asterisks

G

GARY

In my spreadsheet, I've asterisked certain cells.

When I do EDIT/FIND then enter an asterisk in the FIND WHAT box and
press "FIND NEXT", Excel finds EVERY character (not just the
asterisks).

How do I find the asterisks?
 
D

Dave Peterson

Use ~* (tilde asterisk)

You'd need that same tilde for finding a question mark or the tilde itself.

~?
and
~~
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top