Forum Discussion
Solved
TEXTSPLIT with multiple Occurances
Dear Experts, I have a data as attached and for each cell, I need to extract the Text between ", " and "Mhz". So for 1st cell : [] for bcs5: [{1, [6470945]}] and featureSetsW...
That could be
=ARRAYTOTEXT(TOROW(TEXTAFTER(TEXTBEFORE(TEXTSPLIT(A1,"{"), "Mhz" ),","),3))if you are on Excel 365
Table it and then use:
=LET(
split, TEXTBEFORE(TEXTSPLIT([@Strings], "Mhz/"), "Mhz", , , , ""),
mhz, TOROW(split, 3),
TEXTJOIN(", ", , mhz)
)