I have used the concatenate formula to merge three cells into one, but
when I run 'Find' and search for the Concatentated data, it says it
cannot find it.

eg

Column A Column B Column C

Lynne Pike Lynne Pike


When I run Find and search for Lynne Pike, it says that there is no
data there.

Any explantions? This may be the answer to a further problem

Thank you so much

Lynne Pike


--
Lynneth
------------------------------------------------------------------------
Lynneth's Profile: http://www.excelforum.com/member.php...o&userid=26102
View this thread: http://www.excelforum.com/showthread...hreadid=466457