é¦å æä½ æ说çï¼è¿ä¸ªæ°çä½æ°åºè¯¥æ¯å¥æ°ï¼ä¸ç¶å°±æ²¡ææè°çä¸é´ï¼è¯¦è§ä¸å¾ï¼ä¸ç¥éè¿æ¯ä¸æ¯ä½ ææè¿°çææã
å ¬å¼ï¼=LEFT(LEFT(D3,(LEN(D3)-1)/2)&RIGHT(D3,1)&RIGHT(D3,(LEN(D3)-1)/2+1),LEN(D3))
å¤çåçæ°å æ¯D3å¼å§çã
åçå¾ç®åï¼å°±æ¯å 计ç®ä½æ°ï¼ç¶åå°æåä¸ä½ååºï¼å°åæ¥çæ°åæå·¦åé¨åå³åé¨ï¼æåå°±æ¯ä¸ªæ°åç»åã
注æ:å¦ææ¯çº¯æ°åï¼ç¬¬ä¸ä½æ¯0çè¯ï¼æ³¨æåå æ ¼æ ¼å¼æ¹æææ¬æ ¼å¼ï¼ä¸ç¶ç³»ç»ä¼é»è®¤æ²¡æ0ã
å ¬å¼æ¯è¾å¤æï¼æ²¡æä¼åï¼è¿å¯ä»¥å¢å å¥å¶æ°å¤å®ï¼å¦ææ¯å¶æ°å¯ä»¥æ¥éã