Hi!

I want to extract 2 words after is in the folowing string:
My name is John Bon and I don`t want to stay - return John Bon

I want to extract every characters before "is" (include is) in the following string
My name is John Bon and I don`t want to stay - My name is

In some of my rows there is no "is", and I don`t want the crazy symbol, so I need to use "iserror"

Can you help?