我要提取一个地址的市区，用一EXCEL函数怎么表示？
发布网友
共2个回答
热心网友
灞曞紑鍏ㄩ儴=mid(a2,find("鐪?quot;,a2)+1,find(if(countif(a2,"*宸?"锛?"宸?quot;,if(countif(a2,"*甯?"锛?"甯?quot;,if(countif(a2,"*鍖?"锛?"鍖?quot;))),a2)-find("鐪?quot;,a2)-1)涓嬫媺杩介棶鎴戣瘯浜嗕竴涓嬶紝涓嶅彲浠?p>杩界瓟=MID(A2,FIND("鐪?quot;,A2)+1,MIN(FIND({"鍖?quot;,"甯?quot;,"宸?quot;},MID(A2,FIND("鐪?quot;,A2)+1,100)&"鍖哄競宸?quot;)))
热心网友
=mid(a2,find("省",a2)+1,find(if(countif(a2,"*州*"）,"州",if(countif(a2,"*市*"）,"市",if(countif(a2,"*区*"）,"区"))),a2)-find("省",a2)-1)下拉追问我试了一下，不可以
追答=MID(A2,FIND("省",A2)+1,MIN(FIND({"区","市","州"},MID(A2,FIND("省",A2)+1,100)&"区市州")))
热心网友
这个公式应该可以
复制下面公式到B2单元格
=SUBSTITUTE(LEFT(A2,SEARCH(CHOOSE(SUM(ISNUMBER(SEARCH({"市";"州";"区"},A2,4))*{1;2;3}),"市","州","区"),A2,4)),"贵州省",)
格式柄下拉复制公式
