独门首创秘籍：返回包含省市的对应地名：必须excel 2007版本以上才可以用： =IF(COUNTIF(C4,*深圳*),深圳,IF(COUNTIF(C4,*东莞*),东莞,IF(COUNTIF(C4,*穗城*),穗城,IF(COUNTIF(C4,*珠海*),珠海,))))IF(COUNTIF(
|
独门首创秘籍：返回包含省市的对应地名：必须excel 2007版本以上才可以用： =IF(COUNTIF(C4,"*深圳*"),"深圳",IF(COUNTIF(C4,"*东莞*"),"东莞",IF(COUNTIF(C4,"*穗城*"),"穗城",IF(COUNTIF(C4,"*珠海*"),"珠海",""))))&IF(COUNTIF(C4,"*佛山*"),"佛山",IF(COUNTIF(C4,"*中山*"),"中山",IF(COUNTIF(C4,"*江门*"),"江门",IF(COUNTIF(C4,"*惠州*"),"惠州",""))))&IF(COUNTIF(C4,"*汕头*"),"汕头",IF(COUNTIF(C4,"*三水*"),"三水",IF(COUNTIF(C4,"*四会*"),"四会",IF(COUNTIF(C4,"*高明*"),"高明",""))))&IF(COUNTIF(C4,"*开平*"),"开平",IF(COUNTIF(C4,"*恩平*"),"恩平",IF(COUNTIF(C4,"*新会*"),"新会",IF(COUNTIF(C4,"*梅州*"),"梅州",""))))&IF(COUNTIF(C4,"*兴宁*"),"兴宁",IF(COUNTIF(C4,"*五华*"),"五华",IF(COUNTIF(C4,"*清远*"),"清远",IF(COUNTIF(C4,"*梧州*"),"梧州",""))))&IF(COUNTIF(C4,"*贺州*"),"贺州",IF(COUNTIF(C4,"*广西*"),"广西",IF(COUNTIF(C4,"*福建*"),"福建",IF(COUNTIF(C4,"*海南*"),"海南",""))))&IF(COUNTIF(C4,"*海口*"),"海口",IF(COUNTIF(C4,"*三亚*"),"三亚",IF(COUNTIF(C4,"*湖南*"),"湖南",IF(COUNTIF(C4,"*湖北*"),"湖北",""))))&IF(COUNTIF(C4,"*陕西*"),"陕西",IF(COUNTIF(C4,"*四川*"),"四川",IF(COUNTIF(C4,"*重庆*"),"重庆",IF(COUNTIF(C4,"*河南*"),"河南",""))))&IF(COUNTIF(C4,"*安徽*"),"安徽",IF(COUNTIF(C4,"*江西*"),"江西",IF(COUNTIF(C4,"*山西*"),"山西",IF(COUNTIF(C4,"*云南*"),"云南",""))))&IF(COUNTIF(C4,"*贵州*"),"贵州",IF(COUNTIF(C4,"*江苏*"),"江苏",IF(COUNTIF(C4,"*南京*"),"江苏",IF(COUNTIF(C4,"*浙江*"),"浙江",""))))&IF(COUNTIF(C4,"*上海*"),"上海",IF(COUNTIF(C4,"*北京*"),"北京",IF(COUNTIF(C4,"*天津*"),"天津",IF(COUNTIF(C4,"*河北*"),"河北",""))))&IF(COUNTIF(C4,"*辽宁*"),"辽宁",IF(COUNTIF(C4,"*山东*"),"山东",IF(COUNTIF(C4,"*甘肃*"),"甘肃",IF(COUNTIF(C4,"*青海*"),"青海",""))))&IF(COUNTIF(C4,"*宁夏*"),"宁夏",IF(COUNTIF(C4,"*内蒙*"),"内蒙",IF(COUNTIF(C4,"*赤峰*"),"内蒙",IF(COUNTIF(C4,"*黑龙江*"),"黑龙江",""))))&IF(COUNTIF(C4,"*吉林*"),"吉林",IF(COUNTIF(C4,"*新疆*"),"新疆",IF(COUNTIF(C4,"*西藏*"),"西藏",IF(COUNTIF(C4,"*香港*"),"香港",""))))&IF(COUNTIF(C4,"*澳门*"),"澳门",IF(COUNTIF(C4,"*台湾*"),"台湾",IF(COUNTIF(C4,"*广州*"),"广州",IF(COUNTIF(C4,"*顺德*"),"顺德",IF(COUNTIF(C4,"*揭阳*"),"揭阳",IF(COUNTIF(C4,"*湛江*"),"湛江","")))))) (责任编辑：admin) |
支付宝扫一扫
微信扫一扫
备案号：