Find and Concatenate
 

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

When you have the Find Dialog up, click on the Options button. The dialog
should get a littler larger.

Change the "look in" dropdown to "Values" (I bet it was formulas).

Lynneth wrote:

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

--

Dave Peterson