Using FIND on linked text

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
 

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

Excel does not accept text format! 0
Dealing with the error: unable to filter on excel hc home school 0
Help with Sumproduct searching cell contents 2
Visio shape text disappears upon copy paste 1
How do I set focus (and select text) on a text box on a modeless userform? 0
Word macro that can call cells out of Excel for a find and replace 0
Two columns followed by single page-width column on same page 0
formula to count text entries and return text with most entries 12

Top