left(a1,find("°",a1)-1)*60+REPLACE(mid(a1,find("°",a1)+1,10),"'","")
用MIDCHAR函数试一下:MIDCHAR("12°60′","°",1,false)*60+"°"+MIDCHAR("12°60′","°",1,true)
~~~