Find and Concatenate

  • Thread starter Thread starter Lynneth
  • Start date Start date
L

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
 
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate and Vlookup 8
Macro to delete rows with same data 12
Concatenate If 4
Excel Concatenate with line breaks but ignore blank cells 3
IF Function and Concatenation 8
Vlookup using concatenated column indexes 7
How to concatenate cells that meets a specific criteria in threecolumns 6
Concatenate/ Min-Max 2

Back
Top