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.

Hi
search for
~*
or
~?

--
Regards
Frank Kabel
Frankfurt, Germany
"Nick M" <Nick schrieb im Newsbeitrag
...
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.

Precede the wildcard with a tilde, i.e.

~*


Regards,

Peo Sjoblom

"Nick M" wrote:

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.