提问：excel表格经纬度转换

补充 : 如114°18.4611′怎么直接转换为度114.89916667大概就是这个样子的

网友回答：

=LEFT(SUBSTITUTE(A2,"′",""),FIND("°",SUBSTITUTE(A2,"′",""))-1)+MID(SUBSTITUTE(A2,"′",""),FIND("°",SUBSTITUTE(A2,"′",""))+1,100)/60