=LOOKUP(9^9,--MID(A1,MIN(FIND(ROW($1:$9)-1,A1&"0123456789")),ROW($1:$15)))
CTRL+SHIFT+回车
假设内容在A1
B1输入
=LEFT(A1,MATCH(TRUE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),)-1)
按CTRL+SHIFT+回车
C1输入=SUBSTITUTE(A1,B1,"")
B1=IF(SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE($A1,"*",REPT(" ",50)),"\",REPT(" ",50)),COLUMN(A1)*50-49,50)," ",)="","/",SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE($A1,"*",REPT(" ",50)),"\",REPT(" ",50)),COLUMN(A1)*50-49,50)," ",))向下向右复制
也可以像qwe3212630 回答的那样分列，但是在分列前先把分列标志统一起来：用查找替换把星号或斜杠替换成斜杠或星号，再分列一次完成。
=TEXT(LOOKUP(9E+307,--MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW(INDIRECT("$1:$"&LEN(A1))))),"0")
输入好CTRL+SHIF+回车~~~假设在A1