Any chance these strings are in one column?

If yes, you could apply Data|Filter|autofilter to that column.
Filter using Custom
contains type=simple

and then do your edit|replace.

(heck, with just a few columns, it wouldn't be too difficult to do a few times)

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.

--

Dave Peterson