Precede the wildcard with a tilde

~* instead of *

Regards,

Peo Sjoblom


"jeb" wrote:

Hi,
I'm a newbie to Excel and this group so please excuse my ignorance.

I'm trying to do what should be a pretty simple find and replace. I want to
replace:
base=xyz*cntry=123*type=simple
wist
base=differentbase*cntry=123*type=simple

I have to include the type field in my search and the asterik's are part of
the text, not wildcards. The only thing I want to change is the base.
I put this in for the search criteria:
base=xyz*cnty=???*type=simple
This finds all the lines I'm looking for so, so far, so good.
For the replace string, I use this:
base=differentbase*cntry=???*type=simple

The result is that it changes all the cntry='s to ??? instead of just
leaving them alone.

Any suggestions appreciated.