Search for an asterisk

  • Thread starter Thread starter cindee
  • Start date Start date
C

cindee

How can I search for * in a spreadsheet? Everytime I put
* in my search criteria, I get everything.

Thanks,

Cindee
 
cindee said:
How can I search for * in a spreadsheet? Everytime I put
* in my search criteria, I get everything.

Thanks,

Cindee
Click to expand...

The asterisk is the wildcard character - that's why you get everything.
To force Excel to treat it as a 'literal character', precede it with a
tilde.
So, search for ~*
 
Hi Cindee,
In the Find What enter ~* (tilde is next to 1 on top row of 'typewriter'
keys)
I looked in Help under 'wildcard'
Bernard
 
You must log in or register to reply here.

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

Similar Threads

Finding asterisks 2
Asterisk pointing to a footnote 3
Can you delete all asterisks in a sheet? 7
Alt codes 4
Find Last Instance of "Text" in a column 5
Error: Compile Error,ByRef argument type mismatch 0
Macro for Search 6
Searching email subject line for asterisk (*) 4

Back
Top