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.