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
"CLR" <(E-Mail Removed)> wrote in message
news:717D0F8D-01A2-4C94-BEA5-(E-Mail Removed)...
| 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



"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" <(E-Mail Removed)> wrote in message
> news:717D0F8D-01A2-4C94-BEA5-(E-Mail Removed)...
> | 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
> |
> |
>
>
>

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

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
>

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