auto filter doesn't return cells containing the custom search wor.

[annelidae]

Auto filter doesn't always return the word searched for in a column where
each cell contains muplitple names. Is this because of a character limit in
the 'contains' function? How can this issue be solved?

 

[Naveen]

It always returns, I have tried.

Please write your problem clearly.

 

[Debra Dalgleish]

There are instructions here for filtering for text in a long string:

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