You could learn about advanced filter:
http://contextures.com/xladvfilter01.html
(from Debra Dalgleish's site)

Or you could add a helper column that contains a formula that checks for the
strings you want (return true/false or 0/non-zero??) and then filter on this
helper column.

=countif(a2,"*test*") + countif(a2,"*customer*") + ....





MikeD wrote:

Test filet/customer filet allows me to filter for two separate text strings.
I would like to expand this to filter for 10 or 20 text strings. Any help
much appreciated!

--

Dave Peterson