How can I find strings of wildcards in Excel?

[Guest]

I was looking to find strings made up of wildcard characters in Excel, and
I've been having some problems.

For example, I was searching for the string "*?" in my spreadsheet (without
the quotes), and it was directing me to every cell with data in it. If I
search for "{*" (without the quotes), it directs me to every cell with data
that begins with the "{" amperscand character.

Does anyone have a similar problem, or know how to get around this? Thank
you in advance.

 

[Frank Kabel]

Hi
search for
~*
or
~?

 

[Guest]

Precede the wildcard with a tilde, i.e.

~*


Regards,

Peo Sjoblom