How do I search for a * when I'm actually looking for a *?

[anxoperez]

I want to search for instances in my excel document containing the asterisk symbol *, but excel uses it as a wild card.

How do I search for a * when I'm actually looking for a *?

(I'm not looking for macros)

 

[Mike Blackman]

Hi,

I believe you wrap it in Tild's;

~*~

 

[VoG]

You just need one tilde

~*

 

[Mike Blackman]

Hi Vog,

Seemed to work with two as well

Is the second Tilde making it do something it shouldn't?

 

[VoG]

Hi Mike

Just trying to avoid excessive typing

 

[Stormseed]

oh boy! very interesting ! I never knew about this

 

[Mike Blackman]

Cheers Vog, I had assumed that was the case but thought best to check.

 

[anxoperez]

thanks everyone. It certainly works.