Find Feature and Paste Link

  • Thread starter Thread starter Erika
  • Start date Start date
E

Erika

I have a spreadsheet that one entire column populated by a paste link to
another spreadsheet. I am attempting to do a find on that column and it will
not find the text that is returned. Is there another way to do this?
 
If I do a search for the word Texas - I will be looking right at the word
Texas and it will not find it. Obviously what is really in the cell is a
paste link
example
='C:\Docs\VCS\CSS\Mike H\NES\[NES BRANCH LISTING 4-9-08.xls]All Locations'!E9
but it returns the word Texas.
 
Are you matching the entire cell (maybe there's a extra space character???).

Are you looking at formulas or values?

Show the Find dialog and click on the options button to see if you can toggle
one of those settings to get it to work.
If I do a search for the word Texas - I will be looking right at the word
Texas and it will not find it. Obviously what is really in the cell is a
paste link
example
='C:\Docs\VCS\CSS\Mike H\NES\[NES BRANCH LISTING 4-9-08.xls]All Locations'!E9
but it returns the word Texas.

Dave Peterson said:
What are you looking for?

Are you sure that there is a match?
Click to expand...
Click to expand...
 
ps. In xl2002+, you can find based on format, too. Make sure you clear the
formatting, too.

Dave said:
Are you matching the entire cell (maybe there's a extra space character???).

Are you looking at formulas or values?

Show the Find dialog and click on the options button to see if you can toggle
one of those settings to get it to work.
If I do a search for the word Texas - I will be looking right at the word
Texas and it will not find it. Obviously what is really in the cell is a
paste link
example
='C:\Docs\VCS\CSS\Mike H\NES\[NES BRANCH LISTING 4-9-08.xls]All Locations'!E9
but it returns the word Texas.

Dave Peterson said:
What are you looking for?

Are you sure that there is a match?

Erika wrote:

I have a spreadsheet that one entire column populated by a paste link to
another spreadsheet. I am attempting to do a find on that column and it will
not find the text that is returned. Is there another way to do this?
Click to expand...
Click to expand...
Click to expand...
 
Sure enough - it is looking at Formulas - I can not believe I missed that.
Thank you for your assistance.

Dave Peterson said:
Are you matching the entire cell (maybe there's a extra space character???).

Are you looking at formulas or values?

Show the Find dialog and click on the options button to see if you can toggle
one of those settings to get it to work.
If I do a search for the word Texas - I will be looking right at the word
Texas and it will not find it. Obviously what is really in the cell is a
paste link
example
='C:\Docs\VCS\CSS\Mike H\NES\[NES BRANCH LISTING 4-9-08.xls]All Locations'!E9
but it returns the word Texas.

Dave Peterson said:
What are you looking for?

Are you sure that there is a match?

Erika wrote:

I have a spreadsheet that one entire column populated by a paste link to
another spreadsheet. I am attempting to do a find on that column and it will
not find the text that is returned. Is there another way to do this?
Click to expand...
Click to expand...
Click to expand...
 

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

Linking w/Paste Special 1
Excel Linking (I think) 17
Macro to find and move column 1
Zip Code formatting problem 3
Unlink cells- how? 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Alt codes 4
Excel - cut and paste 3

Back
Top