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