Remove alpha characters from alphanumeric string

[azdub2]

I need to remove the alpha characters, from an alphanumeric string. An example of what I have, is in column A and the results I want, are in column B.

A	B
1abcd	1
8.2b	8.2
13.12def	13.12
51ef	51

<tbody>
</tbody>

Any help is greatly appreciated.

 

[Jonmo1]

Thanks Jonmo1, that works perfectly.

You’re welcome.

 

[Jonmo1]

That formula then needs to perform the - operation 16 times, once for each of the 15 LEFT functions +1 on the lookup.

Sorry, disregard that post.
My own formula does the same thing with +0 on the left function.