DMS to degree conversion in excel

A

Absynth

Hi,
I have huge amount of data for latitudes and logitudes in excel and I was
told that they were in DMS format.. Bt the thing is excel doesnt accept my
format as there is no space in between values (DDMMSS or 522378) I noticed in
the other thread that excel only accepts if there were spaces inbetween them
to convert them into decimal degrees.. Can anyone please help me out here..
Thanks..
 
B

Bob Greenblatt

Hi,
I have huge amount of data for latitudes and logitudes in excel and I was
told that they were in DMS format.. Bt the thing is excel doesnt accept my
format as there is no space in between values (DDMMSS or 522378) I noticed in
the other thread that excel only accepts if there were spaces inbetween them
to convert them into decimal degrees.. Can anyone please help me out here..
Thanks..
Click to expand...
If they are always the same length strings, you can use some intermediate
columns to create the proper values. For example, for latitude if the the
data is 522378 and assumed to be ddmmss and in A1, to convert this to the
decimal value that you will probably need for and trig functions using the
data, use the formula:
=left(a1,2)+mid(a1,3,2)/60+right(a1,2)/3600

Make sure your longitudes are three digit degrees, and be careful of
positive and negative values for Northeren/southern, eastern/western
hemispheres.
 
Top