B2è¾å ¥ =LOOKUP(9^9,--RIGHT(LEFT(A2,FIND("*",A2)-1),ROW($1:$99)))
C2è¾å ¥ =LOOKUP(9^9,--LEFT(MID(A2,FIND("*",A2)+1,99),ROW($1:$99)))
D2è¾å ¥ =IFERROR(LOOKUP(9^9,--LEFT(MID(A2,FIND(C2&"*",A2)+1+LEN(C2),99),ROW($1:$99))),0)
3å ¬å¼ä¸æ
追é®è¿ä¸ªå½æ°çâé«âå¨åæ°æ¶ï¼è¥âé¿âåâ宽âçå¼æ¯ä¸æ ·çæ åµä¸ï¼å¼ä¼åéï¼ä¸ç¥è¿æ没æé«æï¼
追çæ¯æè¿ä¸ªé®é¢ï¼ä¸è¿æåæ³
æD2å ¬å¼æ¹ä¸ä¸
=IFERROR(LOOKUP(9^9,--LEFT(MID(SUBSTITUTE(A2,"*",,1),FIND("*",SUBSTITUTE(A2,"*",,1))+1,99),ROW($1:$99))),0)