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
That could be
=ARRAYTOTEXT(TOROW(TEXTAFTER(TEXTBEFORE(TEXTSPLIT(A1,"{"), "Mhz" ),","),3))if you are on Excel 365