Filtering out rows containing specific text

[Sammy22]

hello,

i have data like below and want to filter out anything that has 'abc' but without removing 'no abc'. example of the data below. Only the ones in red would be removed. any help?

BL_PI_Direct

BL_NonC

BL_GY_In

BL_ABC_D

BL_NO ABC_D

BL_ABC

BL_No ABC_In

BL_NO_ABC_sw

[atcodedog05 · Accepted solution]

Hi @Sammy22 

Here is how you can do it.

Workflow:

Hope this helps : )