How to retrieve number from string between "o=" and "&" characters in Ecxel?-CodePudding

Home > Blockchain > How to retrieve number from string between "o=" and "&" characters in Ecxel?

How to retrieve number from string between "o=" and "&" characters in Ecxel?

Time：06-17

I was surfing the net, looking for a solution on how to retrieve the number that I need from a string in Excel. So I have this kinda string:

"somecharacterso=3242&morecharacters"

and I am trying to retrieve the "3242" number according to this