Autofilter over 255 characters in a cell?
 

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

Autofilter over 255 characters in a cell?
 

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
"CLR" wrote in message
...
| 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
|
|

Autofilter over 255 characters in a cell?
 

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



"Jim Rech" wrote:

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
"CLR" wrote in message
...
| 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
|
|

Autofilter over 255 characters in a cell?
 

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



CLR wrote:

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

--

Dave Peterson

Autofilter over 255 characters in a cell?
 

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" wrote:

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



CLR wrote:

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

--

Dave Peterson

Autofilter over 255 characters in a cell?
 

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

CLR wrote:

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" wrote:

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



CLR wrote:

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

--

Dave Peterson


--

Dave Peterson