Combining Formula Search/Replace

I need to be able to do this: Take the value in C2 and tell me if that value is anywhere in cell E2. If it is in E2, perform a FIND with C2 value in only the E2 cell, and REPLACE with "" (blank). This is what I have so far. =IF(SEARCH(C57,E57,1) > 0,"Yes","no")

Can anyone help me out with this?

Maybe all you need is (in a new cell):

=SUBSTITUTE(E2,C2,"")

this will replace the string in C2 if it exists in E2 with a null... otherwise it leaves it alone.