• python
  • javascript
  • reactjs
  • sql
  • c#
  • java
Facebook Twitter Instagram
Devs Fixed
  • python
  • javascript
  • reactjs
  • sql
  • c#
  • java
Devs Fixed
Home ยป Resolved: How to retrieve number from string between “o=” and “&” characters in Ecxel?

Resolved: How to retrieve number from string between “o=” and “&” characters in Ecxel?

0
By Isaac Tonny on 17/06/2022 Issue
Share
Facebook Twitter LinkedIn

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 “&”:
Does exactly as asked.
returns the 3242 as a number.
enter image description here

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

excel
Share. Facebook Twitter LinkedIn

Related Posts

Resolved: significance letter above bar graphic in wrong order

01/04/2023

Resolved: VBA – Applying border around the areas with value/text

01/04/2023

Resolved: How can I implement a function depending on picked up items?

01/04/2023

Leave A Reply

© 2023 DEVSFIX.COM

Type above and press Enter to search. Press Esc to cancel.