åä¸ä¸ªåå æ ¼ç两è¡åï¼
=SUBSTITUTE(A1,"ã",CHAR(10))
å ¬å¼ä¸æã
Bååå æ ¼æ ¼å¼ï¼â对é½âé项å¡ï¼è®¾ç½®ä¸ºèªå¨æ¢è¡ã
追é®ææ³è¦åæè¿æ ·ç ï¼å¯ä»¥åï¼
å¯ä»¥ã
B1=LEFT(A1,FIND("ã",A1)-1)
B2=MID(A1,FIND("ã",A1)+1,99)
å¦ï¼åæ两åæ¯è¾æ¹ä¾¿ï¼æ¹æ³æ¯ï¼
æ°æ®>>>åå>>>åé符å·>>>ä¸ä¸æ¥>>>å¨âå ¶ä»âæ¡ä¸è¾å ¥é¡¿å·>>>å®æã