Autofilter over 255 characters in a cell?

  • Thread starter Thread starter CLR
  • Start date Start date
C

CLR

Hi All........
I use Excel 97, 2k, and XP and it appears that the limit for the number of
characters that the Autofilter can search in a cell is 255. Is there any way
to extend this, and/or does Excel 2003 or 2007 still have this same
limitation?

TIA
Vaya con Dios,
Chuck, CABGx3
 
does Excel 2003 or 2007 still have this same limitation?

Appears unchanged, Chuck. I don't know of a way to change it either.


--
Jim
| Hi All........
| I use Excel 97, 2k, and XP and it appears that the limit for the number of
| characters that the Autofilter can search in a cell is 255. Is there any
way
| to extend this, and/or does Excel 2003 or 2007 still have this same
| limitation?
|
| TIA
| Vaya con Dios,
| Chuck, CABGx3
|
|
 
Thanks Jim.....
I'm making global abbreviations now, and if that don't get them all trimmed
down, will try splitting those cells into two cells with the MID formula and
then searching each separately...maybe.

Vaya con Dios,
Chuck, CABGx3
 
Thanks Dave...........
I did something similar.....I put this in a helper column and then filtered
on it...

=MID(K12,255,1024)

Vaya con Dios,
Chuck, CABGx3
 
I like Debra's technique. It makes it easy to change the value that I'm looking
for.
 
Back
Top