Received-SPF: none
 receiver=logan.com; client-ip=204.127.202.64; envelope-from=n3773@comcast.net
Message-ID: <003c01c571d5$05f37060$f18c1518@rv8>
Reply-To: "kevin lane" <n3773@comcast.net>
From: "kevin lane" <n3773@comcast.net>
To: "Rotary motors in aircraft" <flyrotary@lancaironline.net>
References: <list-1003064@logan.com>
Subject: non-rotary question on spreadsheets
Date: Wed, 15 Jun 2005 11:06:49 -0700
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

  I am working with Quattro spreadsheets, which appear to be identical to 
excel.  my work has me pasting the latitude, longitude into two cells,  they 
originate, however, as one string, missing the decimal points.  It seems 
stupid to be pasting and modifying the string, hundreds of times in a row. 
I'd like to paste the pair into an empty cell and then define the 
destination cells as the portion of the lat/long string.  can you help me? 
I figure if I ask the right person that this is a total no-brainer.

example:    string that I copy from a map "-7719420, 3871104"

I need to split it into two cells that would read "-77.19420"  and 
"38.71104"
they are always the same decimal precision, same length.  I don't see a 
substr function when I look thru the help for Quattro.  I'm getting tired of 
all the tabbing and deleting, not to mention it is very error prone.
    I will be correcting NAVTEQ maps for Jacksonville this week, the US's 
largest city! (area-wise!)  Last time I spent any time there I was bringing 
the brewery on-line! (1982?)  Reply off-list, of course.

Kevin Lane  Portland, OR
e-mail-> n3773@comcast.net