Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Find in Excel 2002 SP3 not finding strings searched for.

Jun 17, 2005 1:11AM PDT

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.

Discussion is locked

- Collapse -
Re: excel search
Jun 17, 2005 3:49AM PDT

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

- Collapse -
excel find and replace issues
Jun 20, 2005 2:37AM PDT

Spreadsheet is work related so can't post it but say the string ''stuff1'' occurs 10 times with in the spreadsheet in different cells or sometimes within the same cell. The find function will only find like 7 of them. Apparently if it found one case with in a cell sometimes it skips over another occurence within the same cell. Other times it will miss an occurence for no reason. Could it be the data is too large? The spreadsheets are well over 1 meg sometimes two. The replace function does not work at all giving a string to long arguement.

- Collapse -
Note the small difference between "find" and "search".
Jun 20, 2005 3:23AM PDT
- Collapse -
I don't think ...
Jun 20, 2005 7:48AM PDT

anybody here can find a solution to your problem without having access to an example where it doesn't work. Maybe invest some time in changing and deleting confidential information?

I think you can easily test the hypothesis that the size of the spreadsheet file matters yourself by making it smaller. It's strange if that should be the problem, but easy to prove or disprove, of course.

Kees