假设“广东省深圳市福田区华强北路2001号深纺大厦”在A1单元格
=MID(TRIM(A1),FIND("市",TRIM(A1))+1,FIND("区",TRIM(A1))-FIND("市",TRIM(A1)))
这可以实现：加入以上是A1，你在B1单元格输入：
=MID(A1,FIND("福田区",A1),3)
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"市",REPT(" ",99)),"区",REPT(" ",99)),99,99))&"区"
=MID(TRIM(A1),FIND("市",TRIM(A1))+1,FIND("区",TRIM(A1))-FIND("市",TRIM(A1)))
=MID(A1,FIND("福",A1),3)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024