How to selectively split cells

alaskanbear52 

It appears the numbers are fixed width. If that's correct, then it looks like the hurdle is splitting the name from the rest of the text string.

Say the data is in Column A (starting in cell A4).

First, find the character position of the first number. This is an array formula, so you have to hit Ctrl+Shift+Enter after keying/copying it into the formula bar.
B4 =MIN(IF(ISNUMBER(--(MID(A4,ROW(INDIRECT("1:"&LEN(A4))),1))),ROW(INDIRECT("1:"&LEN(A4))),""))

Extract the name:
C4 =TRIM(LEFT(A4,B4-1))

Extract the remaining portion of the string:
D4 =MID(A4,B4,LEN(A4))

Copy/paste special - value columns C and D. Then, it looks like you can use text to columns (fixed width) on Column D to separate the rest of the data into columns. I attached a file you can download to look at.