Search for an asterisk

C

cindee

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

Thanks,

Cindee
 
P

Paul

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 ~*
 
B

Bernard Liengme

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
 
Top