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