Using FIND on linked text

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I have a column linked to display the text strings in another column on
another worksheet. Because the actual entry in the cell is a formula and
not the text string, the FIND command doesn't work. Is there a way to
search the displayed strings, rather than actual cell entries?

Ed
 
Thank you, Andy. Sometimes the simplest things seem to slip right on by.

Ed
 
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

Help needed 0
How to look up and pull text from another wkst 1
formula to count text entries and return text with most entries 8
Convert Text to a Formula 5
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
find multipule text strings within a cell 1
find a ?, text acting as number, mysterious single quote 5
Split text string using mid-search? 3

Back
Top