<Chuckle> Ok, forget my long-winded explanations and let's try it this way. Go back to the workbook and:

• Start a Find (<Ctrl-F>).
• In the expanded Options menu, put 'cJ' (mixed case) in the "Find what:" text box.
• Check the "Match case" option (and by "check" I mean turn it on).
• Make sure the "Match entire cell contents" option is off.
• Set "Within:" to "Workbook".

Now do two different searches, one with the "Look in:" option set to "Formulas", and again with it set to "Values" (but with all the above options as described).

As I said before, I'm reaching. But then at this point we're all scratching our heads unsure of what's going on, right?, so maybe I'm a genius and maybe I'm just wasting your time on another unlikely hypothesis, but either way it probably couldn't hoit.

Ok I had to reboot all of Excel b/c all of a sudden I couldn't search in that file either

Now the search is working.

So I did that, but there's no "values" in that drop down.

Nothing for formulas.

No it won't hoit LOL

Thanks

Ok, so when you press tab to go to the next column the result shows cJ rather than CJ?
very strange since the sample sheet you gave me didnt do that. Here is a new experiment. Using the sample sheet that you posted are you still experiencing the same problem or is not an issue with the sample sheet?

Hold on a second: No "Values" setting?

I can't buy that; we must be looking in different places. Here's what I mean (see attached).

Attached Images

x.png (25.1 KB, 9 views)