Re: MI Degrees, Minutes, Seconds to Decimal Degrees?

[Miguel Iturralde]

Ryan,   In Excel, you can use the functions RIGHT, MID, and LEFT to extract characters from a cell.  For example, if you have 40-30-41 in A1, enter the formula =MID(A1,4,2) in cell B1, and hit enter.  The result shown in B1 will be 30.  To copy the formula, drag by the small square on the lower right corner of the cursor, from B1 all the way to the last row with data.   Use the formula bar help wizard in Excel and it will take you step by step.  For example, the above formula instructs to extract the 2 middle values from cell A1, starting at character number 4.  Very important, once you get your values in separate columns, highlight them and do a Copy => Paste Special => Values => Save, so you keep the actual values and not references to another column.   Hope I understood your question and this might be of help.   Regards,   Miguel Iturralde [EMAIL PROTECTED] ----- Original Message ----- From: Ryan Richter To: [EMAIL PROTECTED] Sent: Wednesday, 15 September, 1999 08:46 AM 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 -------------------------------------------------------------------