Question:
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 https://www.ablebits.com/office-addins-blog/excel-regex-formulas/#functions
and stuck with this RegExp:
o=\b(\d+)\b&
but it extracts the full substring not the number only.Answer:
So, now tested and improved:EDIT: based on comment to use “o=” and “&”:

If you have better answer, please add a comment about this, thank you!