1ãå¦æåæ¥æ¯æ¥ææ ¼å¼ï¼å¯ä»¥éæ©æ¤åæ°æ®ï¼è®¾ç½®æç»ä¸çæ¥ææ ¼å¼å³å¯ã
2ãå¦æåæ¥æ¯ææ¬æ ¼å¼ï¼å¯ç¨å
¬å¼æ¹åæç»ä¸æ ¼å¼ï¼å设åæ°æ®å¨Aåï¼å
¬å¼=IF(FIND("/",A1)=5,A1,RIGHT(A1,4)&"/"&MID(A1,FIND("/",A1)+1,LEN(A1)-FIND("/",A1)-5)&"/"&LEFT(A1,FIND("/",A1)-1))ï¼ä¸æå³å¯ã
追é®å¯æ¯å¨åä¸åä¸æ··åè¿è¿ä¸¤ç§æ ¼å¼æä¹ç¨å¢ï¼æ°æ®éå¾å¤§ï¼è½å¦ç¨ä¸ä¸ªå
¬å¼å®æï¼