Filtering a column with a list of values seperated by dashes

[darkblue80]

Hi,

I would like to filter a column whose rows include multiple values separated by dashes. Say:

Column 1
a/b/c
b/d/c
a/f/g

Now I want to filter out the rows which include "a" (in the above example 1st and last row).

Thanks.

[arlu1201]

Hello darkblue80,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

[alansidman]

This is the Introduction Forum where no questions should be posted. If you start a thread in any of the other sub-forums, I´m sure it will not take long before your request will be solved there.