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

why not just run Edit -> Replace ?

This would be easier with an actual workbook to look at showing before/after examples, people so often say one thing and mean another, often quite different.

But if you just want to remove all instances of a text string from a worksheet:

1) Highlight the range of cells to include
2) Press CTRL-H to open the Search/Replace window
3) Enter the search string and leave the replace blank
4) Click on Replace All

The reason a search and replace with blank wouldn't work is, it would still leave anything after &s_kwcid still there

Remember you can use wildcards in your Edit -> Replace search terms just as you did in your SEARCH string... ie:

Replace: &s_kwcid*
With: nothing