But a similar one doesn't work.
As with any problem I post, I still can't solve it after more than two hours of trying. :-(
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityBut a similar one doesn't work.
As with any problem I post, I still can't solve it after more than two hours of trying. :-(
Try:
={REGEXEXTRACT(D2,"ing?"),REGEXEXTRACT(D2,"ziggo")}
Your example in the question can be written as follows:
={REGEXEXTRACT(A1,"banana"),REGEXEXTRACT(A1,"berry")}