excel表中输入地址，在另一列中自动显示城市和省份
展开全部
可以，请参考如下公式：=IF(COUNT(FIND({"北京","天津","河北","山西","内蒙古"},C33)),"华北",IF(COUNT(FIND({"辽宁","吉林","黑龙江"},C33)),"东北",IF(COUNT(FIND({"上海","江苏","浙江","安徽","福建","江西","山东"},C33)),"华东",IF(COUNT(FIND("河南",C33)),"华中",IF(COUNT(FIND({"湖北","湖南","广东","广西","海南"},C33)),"华南",IF(COUNT(FIND({"重庆","四川","贵州","云南","西藏"},C33)),"西南","西北"))))))
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
