怎么excel表中的省份归集为7大地区

=IF(C2="","",IF(COUNT(FIND({"湖州","杭州","萧山","绍兴","宁波","临海","温州","金华","嘉兴"},C2)),"浙江省",IF(COUNT(FIND({"昆山","苏州","无锡","常州","南京","南通","泰州","淮安","徐州"},C2)),"江苏省",IF(COUNT(FIND({"芜湖","合肥","蚌埠"},C2)),"安徽省",IF(COUNT(FIND({"浦东","上海"},C2)),"上海市",IF(COUNT(FIND({"福州","泉州","三明"},C2)),"福建省",IF(COUNT(FIND({"赣州","南昌","横峰","新余"},C2)),"江西省",IF(COUNT(FIND({"临沂","济宁","济南","潍坊","青岛","烟台"},C2)),"山东管理区",IF(COUNT(FIND({"哈尔滨","长春","盘锦","沈阳"},C2)),"东北三省",IF(COUNT(FIND({"北京","天津","衡水","石家庄","太原","侯马","呼和浩特"},C2)),"华北管理区",IF(COUNT(FIND({"西安","兰州","银川","乌鲁木齐","西宁"},C2)),"西北管理区",IF(COUNT(FIND({"漯河","郑州","黄冈","荆州","武汉","武昌","襄阳","衡阳","长沙"},C2)),"华中管理区",IF(COUNT(FIND({"广州","佛山","江门","虎门","深圳","揭阳"},C2)),"华南管理区",IF(COUNT(FIND({"重庆","成都","贵阳","昆明","滇西","南充","自贡","绵阳","西藏"},C2)),"西南管理区",IF(COUNT(FIND({"海口","三亚"},C2)),"海南省",IF(COUNT(FIND({"桂林","南宁","柳州"},C2)),"广西自治区"))))))))))))))))