=SUBSTITUTE(A2,C,"")

assuming you have the valuse in C, if you want to get the numbers without
using column C

=IF(ISERR(--(A1)),LEFT(A1,MATCH(FALSE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LE
N(A1))),1)),0)-1),A1)


entered with ctrl + shift & enter

assuming all numbers are to the left of the letter


--

Regards,

Peo Sjoblom

"Matt M HMS" <Matt M wrote in message
...
Hello and thanks in advance -

I have a column of room numbers with [alphas] mixed in as seen below.

A
100
101D
103F
104
1004E

Note that the numeric values are sometimes in the thousand range. I need
to
create a column B where the numeric value of the room number will be split
up
from column C, the alpha, as below;

A B C
100 100
101D 101 D
103F 103 F
104 104
1004E 1004 E

Matt