Convert Lats and longs to decimals

[dharmik]

I would like to know if there is a way to convert data of lats and longs into decimals in excel.
data is already entered as 27° 13' 26.00" N
and i would like to have it as 27.xxx .
Since I have a huge amount of data I was wondering if we had function that i could drag it for the entire column.

I tried going to cpearson website, but they require you to enter the data in h:mm:ss form. The problem is I already have the data as 27° 13' 26.00" N.

Thanks

Dharmik

[Herbert Seidenberg]

=3D24*SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE
(A1,"""","")," N",""),"=B0 ",":"),"' ",":")

[Herbert Seidenberg]

Or for those Down Under
=3DSUBSTITUTE(SUBSTITUTE
(LEFT(A1,LEN(A1)-3),"=B0 ",":"),"' ",":")*24*
IF(OR(RIGHT(A1,1)=3D"S",RIGHT(A1,1)=3D"W"),-1,1)