B2è¾å ¥
=SUBSTITUTE(SUBSTITUTE(MID(A2,2,99),"é¢ç",),"æ°´æ³¥",)
å ¬å¼ä¸æ
追é®æ没ææå ¬å¸ååè¡å½å ³é®åçå ¬å¼ï¼æ°´æ³¥åé¢çåªæ¯ææçä¸ç§ï¼æå¾å¤ç§ï¼ä¸åºå®çã
追çé£éè¦æä¸ä¸ªå ¬å¸ååè¡çå表ï¼å°±å¯ä»¥å®ç°
å表å¨Dåï¼å¯æ ¹æ®å ·ä½è¡æ°è¿è¡ä¿®æ¹èå´
B2è¾å ¥
=LOOKUP(6^6,FIND($D$2:$D$3,A2),$D$2:$D$3)
å ¬å¼ä¸æ
请问你懂吗?