问题一，已知数据表名址信息，提取乡镇名称。
公式
=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)))))),"(不明分区)","")
