| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 | | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 | | |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
| 2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
| convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
| Excel custom autofilter- how to find wildcard characters but not as wildcards (e.g. "?") in a cell | Excel Discussion (Misc queries) | |||
| Autofilter to search characters that begin with "* " | Excel Discussion (Misc queries) | |||
Hybrid Mode
