æ¨å¥½ï¼å¾é«å
´ä¸ºæ¨è§£çï¼
åè®¾ä½ çæ°æ®å¨Aåä»A1å¼
å¨B1è¾å
¥ä»¥ä¸å
¬å¼ä¸æå¡«å
å°±å¯ä»¥äº
=LOOKUP(9^9,--MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&5^19)),ROW($1:$99)))
论ææçã模çä¸è½½ã论æéå°é¾é¢ï¼è§£å³æ¹æ³ï¼
http://docer.wps.cn/zt/lunwen?from=qyzdæ´å¤WPSåå
¬è½¯ä»¶æç¨ï¼è¯·è®¿é®ï¼
http://bbs.wps.cnæè
http://e.weibo.com/wpswfwå¦æçé®ï¼è¯·ç¹å»æç头åæé®ãç¥æ¨çæ´»æå¿«ï¼