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.
Something like:
=IF(ISNUMBER(SEARCH("Ingredients",E2)),LEFT(E2,SEARCH("Ingredients",E2)-1),"No Ingredients")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
=LEFT(E2,SEARCH("Ingredients",E2&"Ingredients")-1)
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks