Filtering a column with a list of values seperated by dashes

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.

Create a filter and click on the dropdown menu and then go to "Text Filters" and then "Does not contain" and type in the letter you want to filter out.