Thread: Filter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default 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