Excel: convert degrees minutes seconds to decimal
- Joel Lipman
- Excel
- Hits: 4835
A quick article on how to get the value of 40°4′20″N 116°35′51″E into 40.079857, 116.603112.
How?
Let's pretend all the names are in column A, in Column B I have the coordinates that I want to convert:
A B ------------------------------------- ---------------------- Beijing Capital International Airport 40°4′20″N 116°35′51″E Beijing Shahezhen Air Base 40°8′57″N 116°19′17″E Beijing Tongxian Air Base 39°48′40″N 116°42′30″E
- A B
- ------------------------------------- ----------------------
- Beijing Capital International Airport 40°4′20″N 116°35′51″E
- Beijing Shahezhen Air Base 40°8′57″N 116°19′17″E
- Beijing Tongxian Air Base 39°48′40″N 116°42′30″E
Note that I tend to copy the coordinates off a website which has strange apostrophes and double-quotes. You can change this but remember to put two double-quotes if you are searching on it, eg:
FIND(""",B1) // will NOT work! FIND("""",B1) // will work FIND("″",B1) // will work
- FIND(""",B1)  // will NOT work!
- FIND("""",B1)  // will work
- FIND("″",B1)  // will work