how can i extract two words from string that share the same foreword?

June 4, 2022 June 4, 2022 / 1 minute of reading

try:

=INDEX(TEXTJOIN(", ", 1, IFNA(REGEXEXTRACT(SPLIT(A1, ","), "B: (.+)"))))

CLICK HERE to find out more related problems solutions.