| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter
When I try to filter a column with cells filled with text Excel are not able
to find all of the words in a "big" cell (more than 250 charachters). Is there anyone who know if there´s a limit of characters when using filter. Please help Thanks Mia |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter
Text won't be found after 255 characters. There are instructions here
for filtering for text in a long string: http://www.contextures.com/xlautofilter02.html#String Mia wrote: When I try to filter a column with cells filled with text Excel are not able to find all of the words in a "big" cell (more than 250 charachters). Is there anyone who know if there´s a limit of characters when using filter. Please help Thanks Mia -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to link Auto Filter values to a Cell | Excel Worksheet Functions | |||
| Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
| How to make Bullen's FilterCriteria() data refresh real-time? | Excel Discussion (Misc queries) | |||
| Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Linear Mode
