æä¾ä½ ä¸¤ä¸ªå ¬å¼ï¼ä»¥A1为åæ°æ®ä¸ºä¾ï¼å¦å¾ï¼
å ¬å¼ä¸ï¼Excel2019æ365çæ¬ï¼
B1=TEXTJOIN("-",,MID(A1,COLUMN(A:F)*2-1,2))
åæ¶æCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼
å ¬å¼äºï¼å ¶ä»Excelçæ¬
C1=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(A1,11,,"-"),9,,"-"),7,,"-"),5,,"-"),3,,"-")
å°±æ¯ä»11个ä½ç½®å¾åæ¯é2个添å ä¸ä¸ªåé符ã