B2单元格写入公式=IF(A2="","",SUBSTITUTE(SUBSTITUTE(IF(COUNT(FIND("省",A2),FIND("市",A2))=2,MID(A2,FIND("省",A2)+1,FIND("市",A2)-1-FIND("省",A2)),A2),"省",),"市",))下拉填充公式
