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
Bookmarks