Ryan,
If
your text is in cell A1, the Excel formula for:
degrees is
=
|
LEFT(A1,FIND("-",A1)-1)
minutes is
=
seconds is
=
If you have the patience to type these in once
(say in cells B1, C1, and D1) then you can copy them down your 300
rows.
Finally, if you're not sure about converting the
results to lat/long, see
Regards,
Scott Elliott |
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Richter
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 RichterGIS SpecialistDC - Development Consultants(215) 348-4239 ext. 110Fax - (215) 348-4997-------------------------------------------------------------------Suite 312 Penn's Court350 South Main St.Doylestown, PA18901-------------------------------------------------------------------
