=SUBSTITUTE(SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("【】",A1)),"【",""),"】","")
这个连前面那个“重庆市合川区”都去掉了
用SUBSTITUTE函数替换掉方括号和空格
B1=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"【",""),"】","")," ","")
=SUBSTITUTE(SUBSTITUTE(A1,"【",""),"】","")
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024