filter in text

[Robin]

when I use "contains" to filter the text data,I can not get the data that I
want, is there any limit for the text length? the text in cells are longer
than 256 characters.

 

[Debra Dalgleish]

If the search text is located after the 255th character in the cell, it
won't be found. There's a workaround here:

http://www.contextures.com/xlautofilter02.html#String