I have tried to make function which is like =takeif("text1";"text2";range)
text1 is what should be found in the cell and text2 is what should'nt be found.

Example:
A1 contains text "E8811, example, superb"
When I write to B1 function =takeif("E88";"uper";A1) result is blank. If "E88" is found but not "uper" then result is A1.