å设è¿ä¸åæ°æ®å¨Aåã
æ们å¯ä»¥å¨Båæ·»å ä¸ä¸ªè¾
å©åï¼æåºååå é¤è¿ä¸ªè¾
å©åãã
è¿æ ·å¨B1è¾å
¥ï¼
=LEFT(A1,MATCH(0,0/MID($A1,ROW(INDIRECT("1:" &LEN(A1))),1),0)-1)&TEXT(RIGHT(A1,LEN(A1)-MATCH(0,0/MID($A1,ROW(INDIRECT("1:" &LEN(A1))),1),0)+1),"00000#")
åæ¶æä¸CTRL+SHIFT+å车ã
ä¸æå¤å¶å¡«å
åï¼
éæ©Båï¼å¤å¶ï¼å³é®éæ©æ§ç²è´´--æ°å¼ã
éæ©AB两åæåºï¼éæ©Båååºã
ç¡®å®åå é¤Båå³å¯
追é®ä½ 好ï¼è¿ä¸ªæ¹æ³æ¯å¯è¡çï¼ä½æ¯æ´å¸æå®å
¨ç¨vbaæ°ç»æ¥å®ç°ã谢谢ã