Hi:

I am using the FIND feature (as in find/replace) and am getting some
spurious results. Earlier today, this was working just fine, when I would go
and "find" a specific value in a cell (or search for partial values). now,
it does not work. I have this happening more and more, in the specific
worksheet. Last week, find quit working on another tab in the worksheet.
Note that the data is CLEARLY there, but find simply does not "find" it.

Example: Cell A2 contains the text string: Apple Pie

If I perform Edit, Find for Apple Pie, it does not find it, even tho it is
clearly there and existing. Same if I do a partial match, say "Apple" or
"Pie". Yet, even one hour ago, on this same page, I was doing this and it
was working just fine.

Any idea what's up here?

Thanks!

Patk

Check your Options.

Maybe you have "Match Case" selected.

Maybe you have "Look in" Comments selected.


Gord Dibben MS Excel MVP

On Fri, 30 Nov 2007 10:08:04 -0800, PatK wrote:

Hi:

I am using the FIND feature (as in find/replace) and am getting some
spurious results. Earlier today, this was working just fine, when I would go
and "find" a specific value in a cell (or search for partial values). now,
it does not work. I have this happening more and more, in the specific
worksheet. Last week, find quit working on another tab in the worksheet.
Note that the data is CLEARLY there, but find simply does not "find" it.

Example: Cell A2 contains the text string: Apple Pie

If I perform Edit, Find for Apple Pie, it does not find it, even tho it is
clearly there and existing. Same if I do a partial match, say "Apple" or
"Pie". Yet, even one hour ago, on this same page, I was doing this and it
was working just fine.

Any idea what's up here?

Thanks!

Patk

I wish it was that easy, but glad you did not assume. But no...neither of
these are set. What is unique is that the field are "derived" from a vlookup
to another spreadsheet. So, the content is not really there, but elsewhere,
but I have never had an issue with that, before. Also, the data set is not
filtered in any way (sometimes have had problems there).

Thanks for responding, tho!!!!

Patk

"Gord Dibben" wrote:

Check your Options.

Maybe you have "Match Case" selected.

Maybe you have "Look in" Comments selected.


Gord Dibben MS Excel MVP

On Fri, 30 Nov 2007 10:08:04 -0800, PatK wrote:

Hi:

I am using the FIND feature (as in find/replace) and am getting some
spurious results. Earlier today, this was working just fine, when I would go
and "find" a specific value in a cell (or search for partial values). now,
it does not work. I have this happening more and more, in the specific
worksheet. Last week, find quit working on another tab in the worksheet.
Note that the data is CLEARLY there, but find simply does not "find" it.

Example: Cell A2 contains the text string: Apple Pie

If I perform Edit, Find for Apple Pie, it does not find it, even tho it is
clearly there and existing. Same if I do a partial match, say "Apple" or
"Pie". Yet, even one hour ago, on this same page, I was doing this and it
was working just fine.

Any idea what's up here?

Thanks!

Patk

"derived from a vlookup formula" means Apple Pie is returned to A2 via formula?

If so, Excel won't find it AFAIK.


Gord

On Fri, 30 Nov 2007 15:54:04 -0800, PatK wrote:

I wish it was that easy, but glad you did not assume. But no...neither of
these are set. What is unique is that the field are "derived" from a vlookup
to another spreadsheet. So, the content is not really there, but elsewhere,
but I have never had an issue with that, before. Also, the data set is not
filtered in any way (sometimes have had problems there).

Thanks for responding, tho!!!!

Patk

"Gord Dibben" wrote:

Check your Options.

Maybe you have "Match Case" selected.

Maybe you have "Look in" Comments selected.


Gord Dibben MS Excel MVP

On Fri, 30 Nov 2007 10:08:04 -0800, PatK wrote:

Hi:

I am using the FIND feature (as in find/replace) and am getting some
spurious results. Earlier today, this was working just fine, when I would go
and "find" a specific value in a cell (or search for partial values). now,
it does not work. I have this happening more and more, in the specific
worksheet. Last week, find quit working on another tab in the worksheet.
Note that the data is CLEARLY there, but find simply does not "find" it.

Example: Cell A2 contains the text string: Apple Pie

If I perform Edit, Find for Apple Pie, it does not find it, even tho it is
clearly there and existing. Same if I do a partial match, say "Apple" or
"Pie". Yet, even one hour ago, on this same page, I was doing this and it
was working just fine.

Any idea what's up here?

Thanks!

Patk

What you have stated is correct, insofar as how it returns Apple Pie, but it
actually does work. I have other pages (in fact, in the same spreadsheet),
where I can search on the returned value, just fine. Very odd, but I thank
your for your help.

I will keep trying to figure it out....cheers!

patk

"Gord Dibben" wrote:

"derived from a vlookup formula" means Apple Pie is returned to A2 via formula?

If so, Excel won't find it AFAIK.


Gord

On Fri, 30 Nov 2007 15:54:04 -0800, PatK wrote:

I wish it was that easy, but glad you did not assume. But no...neither of
these are set. What is unique is that the field are "derived" from a vlookup
to another spreadsheet. So, the content is not really there, but elsewhere,
but I have never had an issue with that, before. Also, the data set is not
filtered in any way (sometimes have had problems there).

Thanks for responding, tho!!!!

Patk

"Gord Dibben" wrote:

Check your Options.

Maybe you have "Match Case" selected.

Maybe you have "Look in" Comments selected.


Gord Dibben MS Excel MVP

On Fri, 30 Nov 2007 10:08:04 -0800, PatK wrote:

Hi:

I am using the FIND feature (as in find/replace) and am getting some
spurious results. Earlier today, this was working just fine, when I would go
and "find" a specific value in a cell (or search for partial values). now,
it does not work. I have this happening more and more, in the specific
worksheet. Last week, find quit working on another tab in the worksheet.
Note that the data is CLEARLY there, but find simply does not "find" it.

Example: Cell A2 contains the text string: Apple Pie

If I perform Edit, Find for Apple Pie, it does not find it, even tho it is
clearly there and existing. Same if I do a partial match, say "Apple" or
"Pie". Yet, even one hour ago, on this same page, I was doing this and it
was working just fine.

Any idea what's up here?

Thanks!

Patk