=MID(H33,FIND("/",H33,FIND("/",H33,1)+1)+1,10)
=MID(I15,FIND("/",I15,FIND("/",I15,FIND("/",I15,1)+1)+1)+1,10)
江苏省南京市江宁区汤山街道湾曲路[113.488517,38.083729]
截取【后的精度和维度信息】
=SUBSTITUTE(MID(‘工作表1’!Q3,FIND("[",‘工作表1’!Q3)+1,10),",","")
=SUBSTITUTE(MID(‘工作表1’!Q3,FIND(",",‘工作表1’!Q3)+1,10),"]","")