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:
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!