Find Feature and Paste Link
 

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?

Find Feature and Paste Link
 

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?

--

Dave Peterson

Find Feature and Paste Link
 

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" wrote:

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?

--

Dave Peterson

Find Feature and Paste Link
 

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.

Erika wrote:

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" wrote:

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?

--

Dave Peterson


--

Dave Peterson

Find Feature and Paste Link
 

ps. In xl2002+, you can find based on format, too. Make sure you clear the
formatting, too.

Dave Peterson wrote:

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.

Erika wrote:

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" wrote:

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?

--

Dave Peterson


--

Dave Peterson

--

Dave Peterson

Find Feature and Paste Link
 

Sure enough - it is looking at Formulas - I can not believe I missed that.
Thank you for your assistance.

"Dave Peterson" wrote:

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.

Erika wrote:

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" wrote:

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?

--

Dave Peterson


--

Dave Peterson