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
Bookmarks