无论您使用哪种方法，都可以轻松打开和编辑XLSX文件，以满足您的需求。
=LEFT(ASC(TRIM(MID(A2,LARGE(IFERROR(FIND({"省","市","区","县","乡","镇","街道","划"},SUBSTITUTE(SUBSTITUTE(A2,"分区",10),"县级",20)),)+1,2),99))),MIN(IFERROR(FIND({"市","区","县","乡","镇","街道","划"},ASC(TRIM(MID(A2,LARGE(IFERROR(FIND({"省","市","区","县","乡","镇","街道","划"},SUBSTITUTE(SUBSTITUTE(A2,"分区",10),"县级",20)),)+1,2),99))))+LEN({"市","区","县","乡","镇","街道","划"})-1,9^9)))&IF(AND(ISNUMBER(FIND("区)",ASC(TRIM(MID(A2,LARGE(IFERROR(FIND({"省","市","区","县","乡","镇","街道","划"},SUBSTITUTE(SUBSTITUTE(A2,"分区",10),"县级",20)),)+1,2),99))))),ISERR(FIND("区(",ASC(TRIM(MID(A2,LARGE(IFERROR(FIND({"省","市","区","县","乡","镇","街道","划"},SUBSTITUTE(SUBSTITUTE(A2,"分区",10),"县级",20)),)+1,2),99)))))),"(不明分区)","")
1、COUNT函数可以接受多个参数，每个参数都可以是一个范围或一个值。