记下这段代码,本来应该很简单的问题,却费了几个小时。主要是函数的用法,还有理顺思路方面费了些周折。结果还不错:
IF(ISERROR(FIND("区",MID(Q41,FIND(" ",Q41,(FIND(" ",Q41)+1)),FIND(" ",Q41,FIND("Q41,FIND(" ",Q41)+1)+1)-FIND(" ",Q41,FIND(" ",Q41)+1)+1))),MID(Q41,FIND(" ",Q41,(FIND(" ",Q41)+1)),FIND(" ",Q41,FIND(" ",Q41,FIND(" ",Q41)+1)+1)-FIND(" ",Q41,FIND(" ",Q41)+1)+1),MID(Q41,FIND("