如题所述
åå®åæ°æ®å¨Aå,请å¨åé¢æå
¥ä¸ç©ºç½å(å³Bå),å¨B1åå
æ ¼è¾å
¥å
¬å¼:
=IF(LEN(A1)=3,A1,LEFT(A1)&" "&RIGHT(A1))
å°å ¬å¼åä¸å¤å¶å°ç¸åºè¡ã
éå®Båï¼ç¹âå¤å¶âï¼å¨A1ç¹å³é®âéæ©æ§ç²è´´âï¼éä¸âæ°å¼âï¼ç¹âç¡®å®âï¼åå é¤Båå³å¯ã
注ï¼å ¬å¼ä¸åå¼å·ä¸é´æ两个åè§çç©ºæ ¼ã
=IF(LEN(A1)=3,A1,LEFT(A1)&" "&RIGHT(A1))
å°å ¬å¼åä¸å¤å¶å°ç¸åºè¡ã
éå®Båï¼ç¹âå¤å¶âï¼å¨A1ç¹å³é®âéæ©æ§ç²è´´âï¼éä¸âæ°å¼âï¼ç¹âç¡®å®âï¼åå é¤Båå³å¯ã
注ï¼å ¬å¼ä¸åå¼å·ä¸é´æ两个åè§çç©ºæ ¼ã
温馨提示:答案为网友推荐,仅供参考
第1个回答 2014-11-02
切换成全角空格就可以了