filter in text
 

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.

filter in text
 

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

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


Robin wrote:
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
Contextures
http://www.contextures.com/tiptech.html