æåºå¹¶ä¸åªé对æ°åï¼å¯¹äºææ¬ä¹å¯ä»¥ï¼ä½ çé®é¢å
³é®æ¯è¦æXæãX社åååºæ¥ï¼ä½ä¸ºä¸¤ä¸ªä¸åçå
³é®åè¿è¡æåºå³å¯ï¼åæ³å¦ä¸ï¼
1. å
å¦èµ·ä¸¤åï¼æ¯å¦ï¼DãEåï¼åå«åå¨âXæâãâx社âï¼å¹¶åè®¾ä½ çæååäºAåï¼
å¨Dåä¸è¾å
¥å½æ°=LEFT(A1,SEARCH("æ",A1,1))ï¼å¨Eåä¸è¾å
¥å½æ°=MID(A1,SEARCH("æ",A1,1)+1,SEARCH("社",A1,1)-SEARCH("æ",A1,1))
2. 以DãE两å为å
³é®è¯è¿è¡æåºï¼å³å¯å¾å°ä½ è¦ççç»æã
对äºæ使ç¨å½æ°çä»ç»å¦ä¸ï¼
1. Leftå½æ°
å½æ°ï¼ LEFT
说æï¼ LEFT åºäºææå®çå符æ°è¿åææ¬å符串ä¸ç第ä¸ä¸ªæåå 个å符ã
è¯æ³ï¼ LEFT(text,num_chars)
åæ°è¯´æï¼ Text æ¯å
å«è¦æåå符çææ¬å符串ã
Num_chars æå®è¦ç± LEFT ææåçå符æ°ã
Num_chars å¿
须大äºæçäº 0ã
å¦æ num_chars 大äºææ¬é¿åº¦ï¼å LEFT è¿åææææ¬ã
å¦æçç¥ num_charsï¼ååå®å
¶ä¸º 1ã
2. MIDå½æ°
å½æ°ï¼ MID
说æï¼ è¿åææ¬å符串ä¸ä»æå®ä½ç½®å¼å§çç¹å®æ°ç®çå符ï¼è¯¥æ°ç®ç±ç¨æ·æå®ã
è¯æ³ï¼ MID(text,start_num,num_chars)
åæ°è¯´æï¼ Text æ¯å
å«è¦æåå符çææ¬å符串ã
Start_num æ¯ææ¬ä¸è¦æåç第ä¸ä¸ªå符çä½ç½®ãææ¬ä¸ç¬¬ä¸ä¸ªå符ç start_num 为 1ï¼ä»¥æ¤ç±»æ¨ã
Num_chars æå®å¸æ MID ä»ææ¬ä¸è¿åå符ç个æ°ã
3. Searchå½æ°
å½æ°ï¼ SEARCH
说æï¼ SEARCH è¿åä» start_num å¼å§é¦æ¬¡æ¾å°ç¹å®å符æææ¬å符串çä½ç½®ä¸ç¹å®å符çç¼å·ãä½¿ç¨ SEARCH å¯ç¡®å®å符æææ¬å符串å¨å
¶ä»ææ¬å符串ä¸çä½ç½®
è¿æ ·å°±å¯ä½¿ç¨ MID æ REPLACE å½æ°æ´æ¹ææ¬ã
è¯æ³ï¼ SEARCH(find_text,within_text,start_num)
åæ°è¯´æï¼ Find_text æ¯è¦æ¥æ¾çææ¬ãå¯ä»¥å¨ find_text ä¸ä½¿ç¨éé
符ï¼å
æ¬é®å· (?) åæå· (*)ãé®å·å¯å¹é
ä»»æçå个å符ï¼æå·å¯å¹
é
ä»»æä¸ä¸²å符ãå¦æè¦æ¥æ¾çæ£çé®å·ææå·ï¼è¯·å¨è¯¥å符åé®å
¥æ³¢å½¢ç¬¦ (~)ã
Within_text æ¯è¦å¨å
¶ä¸æ¥æ¾ find_text çææ¬ã
Start_num æ¯ within_text ä¸å¼å§æ¥æ¾çå符çç¼å·ã
温馨提示:答案为网友推荐,仅供参考