Isolating numeric values from a character string.

[Bad Rabbit]

Thanks to Mr. Excel contributors, I found out how to use MID(A1, SEARCH("ID=",A1),8) to isolate a specific string of data from a URL.
This already made something which seemed impossible actually work which I am grateful for.

However, the we have new URL structures added and now the result of running the formula leaves me with both numeric, alpha and special characters.
What I am now wondering is if there is a formula that I could run on the outcome to only provide me with the numeric values?

 

[Peter_SSs]

Peter: a couple of points:

1) If the number begins with one or more zeroes, you would need to wrap these in a TEXT formula.
2) There is the (albeit small) chance that certain characters will be present in the string which will cause this to give incorrect results, as is always the danger when using this approach. For example (and given the appropriate language/regional date settings:

ID=10JUN#S

Good points, though I didn't notice them disguised within my quote for some time.

 

[XOR LX]

Good points, though I didn't notice them disguised within my quote for some time.

Yeah, sorry! Wasn't the best idea.