Ryan; In your spreadsheet use the following formulas to convert to decimal degrees substituting your rows and columns for the N21 and O21 cell references below; For Lat. =LEFT(N21,2)+(MID(N21,4,2)/60)+(MID(N21,7,2)/3600) For Long. =-(LEFT(O21,3)+(MID(O21,5,2)/60)+(MID(O21,8,2)/3600)) NOTE THAT THE LONGITUDE IS NEGAITIVE SINCE I AM WEST OF GREENWICH Best regards, Bruce B. Blais Principal Consultant PCN Professionals, Inc. Wireless Telecom Specialists Richardson (Dallas), Texas USA www.pcn-pros.com -----Original Message----- From: Ryan Richter [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 15, 1999 8:47 AM To: [EMAIL PROTECTED] Subject: MI Degrees, Minutes, Seconds to Decimal Degrees? I was given an excel spreadsheet that contained around 300 co-ordinates that I need to plot in MapInfo...Problem, the co-ordinates for both latitude and longitude are all in the same cell, separated by a "-". eg. 40-30-41, and the cell format is just general. If anyone has a quick solution to either separate these numbers into three separate columns (then I can easily convert them into degrees, minutes, seconds), or even better, if someone has devised a program that will work in MapInfo to convert a column in this crummy format to decimal degrees I would love to hear about it ASAP. I have downloaded many of the extra MapBasic utilities on this website and found many of them extremely useful. If one of these will do that and I just haven't found it or figured it out please let me know. Thanks to anyone who can solve this relatively simple, yet pain in the butt problem. Ryan ------------------------------------------------------------------- Ryan Richter GIS Specialist DC - Development Consultants [EMAIL PROTECTED] (215) 348-4239 ext. 110 Fax - (215) 348-4997 ------------------------------------------------------------------- Suite 312 Penn's Court 350 South Main St. Doylestown, PA 18901 -------------------------------------------------------------------
I was given an excel
spreadsheet that contained around 300 co-ordinates that I need to plot in
MapInfo...Problem, the co-ordinates for both latitude and longitude are
all in the same cell, separated by a "-". eg. 40-30-41, and the cell
format is just general. If anyone has a quick solution to either separate
these numbers into three separate columns (then I can easily convert them into
degrees, minutes, seconds), or even better, if someone has devised a program
that will work in MapInfo to convert a column in this crummy format to decimal
degrees I would love to hear about it ASAP.
I have downloaded many
of the extra MapBasic utilities on this website and found many of them extremely
useful. If one of these will do that and I just haven't found it or
figured it out please let me know.
Thanks to anyone who can
solve this relatively simple, yet pain in the butt problem.
Ryan
-------------------------------------------------------------------
Ryan Richter
GIS Specialist
DC - Development Consultants
(215)
348-4239 ext. 110
Fax - (215) 348-4997
-------------------------------------------------------------------
Suite 312 Penn's Court
350 South Main St.
Doylestown, PA
18901
-------------------------------------------------------------------
