excel提取第二次出现的城市的公式答:第一个 =SUBSTITUTE(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",20)),(LEN(A1)-LEN(SUBSTITUTE(A1,"市",))+1)*20-19,20)),"市",)试试.第二个 =RIGHT(LEFT(A1,LOOKUP(99,FIND({"区","县"},A1))),MATCH(" ",LEFT(RIGHT(LEFT(A1,LOOKUP(99,FIND({"区","县"},A1))),{1,2,...