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. 🙁
Google-sheets – How to use non capturing groups in google sheets
google sheetsregexregexextract
Related Topic
- Google Sheets – VLOOKUP Problem with Value from ArrayFormula and RegexExtract
- Google-sheets – How to modify REGEXEXTRACT to import total hours played on Steam
- Google-sheets – Import Price from Gamestop Into Google Sheets
- Google Sheets – Resetting Reference After Deleting and Replacing a Sheet
- Google-sheets – Google Sheets Conditional Formatting Isn’t Working
- Google Sheets – Conditional Formatting Guide
- Google-sheets – How to you use a Gmail script to attach more than one image at a time
Best Answer
Try:
={REGEXEXTRACT(D2,"ing?"),REGEXEXTRACT(D2,"ziggo")}Your example in the question can be written as follows:
={REGEXEXTRACT(A1,"banana"),REGEXEXTRACT(A1,"berry")}