How do I use non capturing groups in google sheets?

Question

This is what I intend to do.

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. :-(

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. — marikamitsos, 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

Tedinoz · Accepted Answer · 2020-07-24 01:33:03Z

0

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

Your example in the question can be written as follows:

={REGEXEXTRACT(A1,"banana"),REGEXEXTRACT(A1,"berry")}

answered Jul 23, 2020 at 23:58

Tedinoz

5,5202 gold badges12 silver badges30 bronze badges

Add a comment |

1 Answer 1