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.
NotesImportant textMy standard text.>>This is important 1<< Another standard text >>Important 2<<
Next standard textThis is important 1
Important 2
Similar issue to the https://techcommunity.microsoft.com/t5/excel/formula-for-extracting-multiple-occurrences-of-values-following/m-p/4178824 solved by @HansVogelaar , but now we have both opening and closing tag the same, so the TEXTSPLIT function removes all markups …
Thank You very much for any hint.
Zdenek Moravec
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.NotesImportant textMy standard text.>>This is important 1<< Another standard text >>Important 2<<Next standard textThis is important 1Important 2Similar issue to the https://techcommunity.microsoft.com/t5/excel/formula-for-extracting-multiple-occurrences-of-values-following/m-p/4178824 solved by @HansVogelaar , but now we have both opening and closing tag the same, so the TEXTSPLIT function removes all markups …Thank You very much for any hint.Zdenek Moravec Read More
