I need to pull a text string from one column and move it over to a new column but if it has the word "Ingredients" in it I need to only copy the text before the word "Ingredients". My problem is that if the word "Ingredients" is not there I get the error #value!.

The formula i am using is =LEFT(E2,SEARCH("Ingredients",E2)-1)

Thanks.