|The core formula is something I found on the ole' interweb for extracting a number from a text string. I won't claim to completely understand it (feel free to figure it out for us, if you want) but what is does is extract the first series of digits it finds between 2 letters or before the first letter if the string starts with a number. In other words...|
a123b45678 --> 123
5678z1223 --> 5678
Since the example data in the OP doesn't include any "text", I forced some spaces into the value in A1 with:
SUBSTITUTE(A1,MID(A1,12,1),REPT(" ",1) and
As I said, I don't completely understand how the core formula works, so I just used some "intelligent guessing" until I came up with a formula that returns the "7-11th digits from a string of numbers" as requested.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.