=IF(COUNT(FIND("上海",A1)),"华东",IF(COUNT(FIND("广州",A1)),"华南",""))
B1=if(iserror(find("上海",A1)),if(iserror(find("广州",A1)),"","华南"),"华东")
