https://eblog.ink/archives/267/ 1.以数据在A1为例方法1:省=LEFT(A1,MIN(FIND({"省","市","区"}, A1&"省市区&qu...