如题所述
è§æªå¾
B1è¾å ¥
=LEFT(A1,FIND("*",A1)-1)
C1è¾å ¥
=MID(A1,FIND("*",A1)+1,FIND("*",SUBSTITUTE(A1,"*",1,1))-FIND("*",A1)-1)
D1è¾å ¥
=MID(A1,FIND("*",SUBSTITUTE(A1,"*",1,1))+1,9)
å ¬å¼ä¸æ