Thanks but I can't do it that way. There are hundreds of different cntry's in
the find list. So it could be 123 or 456, etc. That's why I use ??? in the
find statement, so I find them all. But I don't want to change that value
when I do the replace.

So the lines I'm searching for could be:
base=xyz*cntry=123*type=simple
base=xyz*cntry=456*type=simple
base=xyz*cntry=789*type=simple

I want to find all the different cntry's but only of type simple. There are
multiple type's, too, so I have to define it in my search.

John



"swatsp0p" wrote:

>
> Excuse me for jumping into this, but <only> use the wildcards in the
> Find operation, not the replace. Type in the EXACT information you
> want the cell to end up with.
>
> Good Luck!
>
>
> --
> swatsp0p
>
>
> ------------------------------------------------------------------------
> swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
> View this thread: http://www.excelforum.com/showthread...hreadid=332653
>
>