Extract Numbers Only from cell

Hi All,
I have a data set that I imported from Access. One of the columns contains the code for specific work activities, for example 13Z or 9A. I need to extract the numbers only from the cells in that column so that they are in separate cells in a separate column. I've been trying to use left, right, or mid functions, as well as text to columns with varying degrees of success. Any ideas on what the best method for doing this may be?

Thanks in advance!

Assuming as per your examples that the numbers always precede the alpha characters and there is only one number within the string then

=LOOKUP(9.99E+307,--MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&1234567890)),ROW(INDIRECT("1:"&LEN(A1)))))

Where A1 holds the string 13Z etc... adjust ranges to suit.