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
Hi Hecatonchire can you please share the same formula for Python in excel?
- Hi,
=WEBSERVICE("https://e.anyoupin.cn/eh3/?preg_match_all_join~(?<=\s)\d+(?=Mhz)~" & A2)
Try this webservice. That could be
=ARRAYTOTEXT(TOROW(TEXTAFTER(TEXTBEFORE(TEXTSPLIT(A1,"{"), "Mhz" ),","),3))if you are on Excel 365
