https://eblog.ink/archives/267/ zh-CN 1.以数据在A1为例方法1:省=LEFT(A1,MIN(FIND({"省","市","区"}, A1&"省市区&qu... Thu, 01 Jan 1970 00:00:00 +0000 Thu, 01 Jan 1970 00:00:00 +0000