Autofilter over 255 characters in a cell?

[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

 

[Jim Rech]

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
|
|

 

[CLR]

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

 

[Dave Peterson]

Maybe you could use this technique from Debra Dalgleish's site:
http://contextures.com/xlautofilter02.html#String

 

[CLR]

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

 

[Dave Peterson]

I like Debra's technique. It makes it easy to change the value that I'm looking
for.