0

How do I extract the next word or number (including comma and delimiter) to a search string from a cell in sheets?

And how the previous?

={$AV$14;
ArrayFormula(IF(ISBLANK($AT$2:$AT),,
iferror(
value(REGEXEXTRACT($AT$2:$AT,"([0-9]*\.[0-9]+[0-9]+)\s+meters|M2"))
)))}

works mostly fine for finding the "previous" number to a search term, however, I am not sure, if this all elegant. I am pretty new to regex.

Any help is greatly appreciated.

1
  • Welcome. Please share some test data instead of just the formula so as you can be easier helped. Even better, please read how to and share a test sheet. – marikamitsos Mar 1 at 18:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.