excel表中输入地址,在另一列中自动显示城市和省份
答案:1 悬赏:20 手机版
解决时间 2021-01-19 04:39
- 提问者网友:喧嚣尘世
- 2021-01-18 10:17
excel表中输入地址,在另一列中自动显示城市和省份
最佳答案
- 五星知识达人网友:想偏头吻你
- 2019-05-04 22:28
可以,请参考如下公式:=IF(COUNT(FIND({"北京","天津","河北","山西","内蒙古"},C33)),"华北",IF(COUNT(FIND({"辽宁","吉林","黑龙江"},C33)),"东北",IF(COUNT(FIND({"上海","江苏","浙江","安徽","福建","江西","山东"},C33)),"华东",IF(COUNT(FIND("河南",C33)),"华中",IF(COUNT(FIND({"湖北","湖南","广东","广西","海南"},C33)),"华南",IF(COUNT(FIND({"重庆","四川","贵州","云南","西藏"},C33)),"西南","西北"))))))
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯