GPS坐标转换函数

　　近日在整理一些用手机拍摄的照片，但很多已经记不起在哪里拍照了，幸好当时开了定位功能，在图片文件中记录了拍摄地点的经纬度。但通过ACDSee软件查看图片时，显示的经伟度是“度分秒”的形式如：109, 26' 29.447"，而使用百度地图使用的是“109.4413889”格式，所以需要使用函数转换。于是用EXCEL简单做了一个转换公式如下。

	A	B	C	D
1	(粘贴度分秒格式坐标值)	=LEFT(SUBSTITUTE(A1," ",""),FIND(",",SUBSTITUTE(A1," ",""))-1)+C1+D1	=MID(A1,FIND(" ",A1)+1,FIND("'",A1)-FIND(" ",A1)-1)/60	=MID(SUBSTITUTE(A1," ",""),FIND("'",SUBSTITUTE(A1," ",""))+1,2)/3600

说明：

        A1用于输入度分秒格式座标值，如：109, 26' 29.447"

        B1用于读取A1的“度”数值，再加上C1和D1值，得到转换后的最终值，公式为：=LEFT(SUBSTITUTE(A1," ",""),FIND(",",SUBSTITUTE(A1," ",""))-1)+C1+D1

        C1用于获取A1中“分”的数值，再除以60得到以“度”为单位的转换值，公式为：=MID(SUBSTITUTE(A1," ",""),FIND(",",SUBSTITUTE(A1," ",""))+1,FIND("'",SUBSTITUTE(A1," ",""))-FIND(",",SUBSTITUTE(A1," ",""))-1)/60

        D1用于获取A1中“秒”的数值，再除以3600得到以“度”为单位的转换值，公式为：=MID(SUBSTITUTE(A1," ",""),FIND("'",SUBSTITUTE(A1," ",""))+1,2)/3600