Forum Discussion
Solved
How to extract multiple occurrences of a text enclosed between two same characters
Dear colleagues, I have a cell with plenty of text. Some part of the text is enclosed between tags >> and <<. The task is to extract all these strings to one cell, separated by new line. Notes ...
I hope this works for you (with the text in A5):
=LET(w, TEXTSPLIT(A5, "!"), n, COUNTA(w), s, SEQUENCE(, n), f, FILTER(w, ISEVEN(s)), TEXTJOIN(CHAR(10), TRUE, f))
A start might be
= TEXTJOIN(
CHAR(10),,
REGEXEXTRACT(targetString, ">[\w|\s]*(?=<)", 1)
)
Regular expressions is a topic for next sleepless nights, once the functions come to M365 Basic 😉 I will notice Your solution and learn on it ...