I have a need to test the cell contents to determine if the cel
contains specific text in any of its contents. This is like using th
"find" feature.

I want to test if a cell contains "LA" for instance. If true then
want to copy the entire cell and then compare it to another cell.

Any help?

Thanks Bil

--
bilsw
-----------------------------------------------------------------------
bilswi's Profile: http://www.excelforum.com/member.php...fo&userid=1612
View this thread: http://www.excelforum.com/showthread.php?threadid=27567