In Cell C1 enter:
=IF(ISNUMBER(FIND(B1,A1)),A1,A1&" Not Found")
and copy down.
HTH

"PLPE" <PLPE.1pulic_1117461904.3583@excelforum-nospam.com> wrote in message
news:PLPE.1pulic_1117461904.3583@excelforum-nospam.com...
>
> Column A & B do not match exactly, but are pretty close.
> Originally, both columns had '_' & '@' included, but I added macros to
> getr rid of these - easier to do comparisons (methinks!).
>
> Here are some of my entries;
>
> [Col A];
> RD INP LKG 0V
> RD INP LKG 5V25
>
> [Col B];
> RD INP LKG 5V25 nA
> CS INP LKG 5V25 nA
>
> [Col C];
> RD INP LKG 5V25 - Found
> CS INP LKG 5V25 nA - Not Found
>
>
> {I think *Jindon* has me on the right track, but it's still not working
> for me!}
>
>
> --
> PLPE
> ------------------------------------------------------------------------
> PLPE's Profile:
http://www.excelforum.com/member.php...o&userid=23856
> View this thread: http://www.excelforum.com/showthread...hreadid=375010
>