In column D, I have a column of strings like below:

3 M1
4 S2
5 S8
6 M0
7 M10
etc

The M or S will always be 1st & the number will be no more the 10.

I need the simplest formula possible to extract the number out in column E of the same row, for example:

3 1
4 2
5 8
6 0
7 10
etc

Thanks for all your help. mikeburg