å¯ä»¥å©ç¨EXCELä¸çMIDåSEARCHå½æ°å
±åå®ç°è¿ä¸ªåè½ã
SEARCHå½æ°çåè½æ¯è¿åä¸ä¸ª
å符串å¨å¦ä¸ä¸ªå符串ä¸ä»å·¦å°å³ç¬¬ä¸æ¬¡åºç°çä½ç½®ç´¢å¼ï¼MIDå½æ°åæ¯ç¨äºæªåå符串çã
åå¦ï¼å¨ä¸ä¸ªå
å«å®¢æ·è¯¦ç»ä½æä¿¡æ¯çå符串ä¸ï¼å¦æä½ è¦æªåæä¸çæå¨å¸çä¿¡æ¯ï¼å¯ä»¥å©ç¨ä¸é¢çå
¬å¼ç»åå®ç°ï¼åå®è¯¥å符串æ¾ç½®äºH1åå
æ ¼ä¸ï¼ï¼
IF(OR(ISERROR(SEARCH("ç",H1,1)),ISERROR(SEARCH("å¸",H1,1))),"æ ¼å¼ä¸ç¬¦",
MID(H1,SEARCH("ç",H1,1)+1,SEARCH("å¸",H1,1)-SEARCH("ç",H1,1)))
ä¸é¢çå
¬å¼ä¸ï¼ååé¨å
IF(OR(ISERROR(SEARCH("ç",H1,1)),ISERROR(SEARCH("å¸",H1,1)))
æ¯ç¨äºå¤æä¸ä¸ªå符串æ¯å¦å
å«âçâãâå¸â两个å符ï¼å¦æåªå
å«å
¶ä¸ä¸ä¸ªæ两个é½ä¸å
å«ï¼IFè¯å¥ä¼è¿åâæ ¼å¼ä¸ç¬¦"æ示信æ¯ï¼ISERR
ORå½æ°ç¨äºå¤æç»å®å¼æ¯å¦ä¸ºéå¼å¹¶æ®æ¤è¿åTRUEæ FALSEï¼ORå½æ°ç¨äºå¯¹å¹¶åçæ¡ä»¶è¿è¡ç伪å¤æï¼èå
¶ä¸çSEARCHå½æ°å¨ä½¿ç¨æ¶éè¦ä¸ä¸ªåæ°ï¼
1ã第ä¸ä¸ªæ¯éè¦æ¥æ¾çå符串ï¼å¦âçâãâå¸â
2ã第äºä¸ªåæ°æ¯è¡¨ç¤ºä¸ä¸ªæ¥æ¾èå´çå符串æåå
æ ¼å¼ç¨ï¼å³å¨ä»ä¹å°æ¹æ¥æ¾ï¼ï¼å¦ä¸é¢çH1åå
æ ¼ã
3ã第ä¸ä¸ªåæ°æ¯è¡¨ç¤ºå¼å§æ¥æ¾çä½ç½®ï¼ä¸è¬é½ä¸º1ï¼ä¸é¢çå
¬å¼æ¯ä»H1åå
æ ¼ç第ä¸ä¸ªä½ç½®å¼å§æ¥æ¾)ã
å½æ°çååé¨åï¼
MID(H1,SEARCH("ç",H1,1)+1,SEARCH("å¸",H1,1)-SEARCH("ç",H1,1)))
æ¯ç¨äºæªåå符串çã
æªåçè¿ç¨å¨äºç¡®å®æªåçå¼å§ä½ç½®åä½æ°ã
SEARCH("ç",H1,1)+1表示æªåæ¶å¼å§çä½ç½®ï¼å³ä»âçâå第ä¸ä¸ªå符æªåã
SEARCH("å¸",H1,1)-SEARCH("ç",H1,1))表示è¦æªåçå符æ°ï¼å³ä¸ä¸ªå符串ä¸ä»äº"ç"å"å¸"ä¹é´çå符ã
éè¦æ³¨æçäºï¼SEARCHå½æ°ä¸åºå大å°åï¼å¦æä½ è¦æ¥æ¾åæä½çæ¯åæ¯ä¸åºå大å°åçè¯ï¼å¯ä»¥ç¨FINDå½æ°ä»£æ¿SEARCHå½æ°ã
æå
³MIDå½æ°ç使ç¨ï¼å¯ä»¥åèä¸é¢ï¼
http://zhidao.baidu.com/question/365370576æå
³ISERRORåORå½æ°ç使ç¨ï¼å¯ä»¥åèä¸é¢ï¼
http://www10.zzu.edu.cn/ie_wangjunfeng/daquan/function/contents/IsError.htmhttp://jingyan.baidu.com/article/6b1823095115c5ba58e15932.html