Find and Concatenate

[Lynneth]

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

 

[Dave Peterson]

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).