Attn: BOB PHILLIPS:

How did you ever have the wherewithal to come up with your formula:

=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"01234 56789")),SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(A1,{0,1,2,3,4,5,6,7,8,9},""))))

which separates the "number" portion of the data (such as 'splitting' 19a
into 19??????

Please advise! I am fully aware that it works perfectly, but without your
input, I NEVER could have done this on my own!!

Thanks,

FLKulchar
"Bob Phillips" wrote in message
...
B1:
=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"01234 56789")),SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(A1,{0,1,2,3,4,5,6,7,8,9},""))))
C1: =SUBSTITUTE(A1,B1,"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Dot" wrote in message
...
How do I split a cell with numbers and letters into 2 separate cells. I
have
tried the text to columns wizard and can't figure it out. Here is an
example
of what I am trying to split. There are no spaces between the numbers
and
letters.
A1: 9A
A2: 9B
A3: 19A
A4: 19C