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 '20 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 '20 at 11:33

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, privacy policy and cookie policy

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