提取省
=LEFT(H2,MIN(FIND({"省","市","区"},H2&"省市区")))
提取市
=LEFT(SUBSTITUTE(H23,I23,""),MIN(FIND({"市","区","县","州"},SUBSTITUTE(H23,I23,"")&"市区县州")))
提取县
=LEFT(SUBSTITUTE(H2,I2&J2,""),MIN(FIND({"市","区","县"},SUBSTITUTE(H2,I2,"")&"市区县")))
=LEFT(H2,MIN(FIND({"省","市","区"},H2&"省市区")))
=LEFT(SUBSTITUTE(H23,I23,""),MIN(FIND({"市","区","县","州"},SUBSTITUTE(H23,I23,"")&"市区县州")))
=LEFT(SUBSTITUTE(H2,I2&J2,""),MIN(FIND({"市","区","县"},SUBSTITUTE(H2,I2,"")&"市区县")))