我要提取一个地址的市区,用一EXCEL函数怎么表示?答:=mid(a2,find("省",a2)+1,find(if(countif(a2,"*州*"),"州",if(countif(a2,"*市*"),"市",if(countif(a2,"*区*"),"区"))),a2)-find("省",a2)-1)下拉
excel 分类函数 我要把中国三十几个省分区域,比如东三省是北区,然后...答:可以的,你先做一个省分与区域的对应表,比如你在F列输入省分G列输入对应的区域,你要A1输入省分,B1显示区域,那你在B1输入=VLOOKUP(A1F:G,2,0)。还有是直接用IF函数,在B1输入=IF(OR(A1={"吉林","辽宁","黑龙江"}),"北区",IF(OR(A1={"上海","江苏","浙江"}),"东区",))