Forum Discussion
Formula for extracting multiple occurrences of values following a similar string of text
Hi Tech Community! I am trying to write a formula that will allow me to extract multiple strings of numbers from one cell to another, while filtering out all other irrelevant text from the source cel...
In B2:
=TEXTJOIN("; ", TRUE, IFERROR(TEXTBEFORE(TEXTSPLIT(A2, "ABCD: "), ")"), ""))
HansVogelaar thank you for the speedy response. Unfortunately that didn't exactly work the way I was hoping (see image below).
Your text has ABCD: but the formula uses PMID:
The formula works correctly with ABCD:
