Excel 2007 : Search specific text in a string

Thanks JBeaucaire!

It worked. If we want to filter rows on two inputs like "wxy" and "abc" then will this formula works with OR operator?

I appreciate your help.