Search for specific text in a string and replace

Hello,

I have a text such as:


fdfs&s_kwcid
sfsd&s_kwcid=dfsads
&dfsdaf&dsafdsf&s_kwcid=
fdsf&dasfsdf&s_kwcid=dsfasfsdf



etc.

What I want to do is search for "&s_kwcid" or anything containing "&s_kwcid" and replace it with blank.

So above would then read:

fdfs
sfsd
&dfsdaf&dsafdsf
fdsf&dasfsdf


I tried =IF(SUM(COUNTIF(E2,{"&s_kwcid*"}))=1,E2,"") but it didn't work.

I tried auto filtering, and using contains &s_kwcid* but it didn't filter out results, but find &s_kwcid did find results for text anywhere in string, so I know the problem is there.

Any help would be apprecaited.

Thanks