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.