Formula wanted to extract the middle, not the Left and Right bits.

**rbion** · 08-02-2012, 02:56 PM

Is there a simple formula that will take the contents of a cell (example ABC1234567A) and in the empty cell beside it leave just the numbers (1234567)?

**Ron Coderre** · 08-02-2012, 03:05 PM

With
A1: a text-number-text string.....example: ABC9701.23ZXR
This regular formula pulls the first series of consecutive numbers (including decimals) from that string
B1: =LOOKUP(99^99,--MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW(INDIRECT("1:"&LEN(A1)))))

In that example, the formula returns: 9701.23

Note: that formula can only recognize numbers that are 15 characters or less. If you need more, there's another approach.

Is that something you can work with?

**rbion** · 08-02-2012, 03:17 PM

Thank you Ron, not only did it work, but you have now given me some homework tonight (to look up and learn about each component in that formula, there are many parts in that line I haven't seen before). Very much appreciated.