Is there is any way to filter data using a part of the string
Name Details1 Details2 Details3 Tag
Luffy xxxx xxxx xxxx Flag1|Flag2
Zorro YYYY YYYY YYYY Flag2|Flag3|Flag4.
Ussop ZZZ ZZZ ZZZZ Flag1|Flag5
Nami RRR RRR RRRR Flag3|Flag6
Brook QQQQ WWW QQQQ Flag4|Flag7
Robin OOOO OOOO OOOO Flag3|flag8
Franky FFFF FFFF FFFf Flag1|Flag9
The data are shown above, I wanted to create a filter and consist of contains filter in excel
Name Details1 Details2 Details3
Ussop ZZZ ZZZ ZZZZ