Sounds unfamiliar to me. Can you put the spreadsheet on a website (your homepage, if you have one) and post a link to it, together with some more instructions. Then someone here can have a look at the problem.
It might make sense to make a specific example without real data, of course. We're just interested in the problem, not in your data.
Kees
I am using Find (press control F) to search an Excel data base for a partial link string like "/stuff/stuff2" where the links are in a field containing html code and it misses occurences of that string if I manually look through the cells I find occurences that the find missed.
Settings are No Format Set. Within - Sheet, Search - By Rows, Look in - Forumula.
I tried values for Look in and it found some more but I still found like 2 that it missed. Search by Rows Or Columns doesn't seem to matter.
Is there a specific patch I need to download or something else I need to set? Please help.
Thank you in advance.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic