I haven't been able to find an answer to this yet. Hopefully someone can help. Here's the situation...
I have a spreadsheet containing about 20 columns and about 200 rows (a list of sorts). One of the columns contains a text string. This text string can be anywhere from being blank, to having 4000 to 5000 characters. It basically contains a set of names of people who subscribed to the program identified on that record.
I'm trying a simple autofilter where I look for a persons name in that text string and filter to all the rows containing his/her name. This works at times and at times doesn't. It basically depends upon how far down in the text string that persons name appears. If it is near the beginning, the filter works fine. But if it is out near the end the filter fails.
It seems there is some sort of limitation on the size of a string that can be searched. If I simply to a FIND from the excel menu and search for that same name that failed in the filter, it also fails in the FIND.
Yes, I'm absolutely certain that it is not a spelling issue. I've tried with and without wildcards and again the wildcards work fine if the name is early in the string but fail if the name is late in the string.
Has anyone run up against this sort of thing, and/or does anyone have any suggestions for a workaround?
Thanks in advance.
I have a spreadsheet containing about 20 columns and about 200 rows (a list of sorts). One of the columns contains a text string. This text string can be anywhere from being blank, to having 4000 to 5000 characters. It basically contains a set of names of people who subscribed to the program identified on that record.
I'm trying a simple autofilter where I look for a persons name in that text string and filter to all the rows containing his/her name. This works at times and at times doesn't. It basically depends upon how far down in the text string that persons name appears. If it is near the beginning, the filter works fine. But if it is out near the end the filter fails.
It seems there is some sort of limitation on the size of a string that can be searched. If I simply to a FIND from the excel menu and search for that same name that failed in the filter, it also fails in the FIND.
Yes, I'm absolutely certain that it is not a spelling issue. I've tried with and without wildcards and again the wildcards work fine if the name is early in the string but fail if the name is late in the string.
Has anyone run up against this sort of thing, and/or does anyone have any suggestions for a workaround?
Thanks in advance.