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?


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.

  • 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.