This is what I intend to do. enter image description here

But a similar one doesn't work. enter image description here

As with any problem I post, I still can't solve it after more than two hours of trying. :-(


  • Please avoid providing just an image in your questions. Images cannot be properly indexed by search engines (like Google or SE). Edit your question writing both the formulas you have tried and the expected results as found here or here. Even better please read how to and share a test sheet so as you can be easier helped. Jul 22, 2020 at 20:39
  • What would the result you are after look like, in other words, what exactly is it you are trying to achieve?
    – JvdV
    Jul 24, 2020 at 11:33

1 Answer 1


Try: ={REGEXEXTRACT(D2,"ing?"),REGEXEXTRACT(D2,"ziggo")}

Your example in the question can be written as follows:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.