å¯ä»¥éè¿å®ä½æå·æå¨çä½ç½®ï¼â* åé¢çæ°åå¯ä»¥ç¨leftï¼ï¼å½æ°ï¼â* åé¢çæ°åå¯ä»¥ç¨rigthï¼ï¼ï¼å ·ä½æ¥éª¤å¦ä¸ï¼
1ãæå* åé¢çæ°åï¼æ¥æ¾æå·çä½ç½®:FIND("*",A2),æå第ä¸ä½è³å ¶åä¸ä½å³ç¬¬FIND("*",A2)-1ä½ï¼å½æ°ä¸ºï¼
=LEFT(A2,FIND("*",A2)-1)
2ãæåâ*âä¹å³æ°åï¼lenï¼ï¼è·å¾æ´ä¸ªå符串é¿åº¦ï¼lenï¼A2ï¼-FIND("*",A2)è·å¾æå·ä»å³æ°çä½ç½®ãåæåå³ä¾§å符ï¼=RIGHT(A2,LEN(A2)-FIND("*",A2))