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

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