Mailing List flyrotary@lancaironline.net Message #23955
From: Joe Hull <JoeH@PilgrimTech.com>
Subject: RE: [FlyRotary] non-rotary question on spreadsheets
Date: Wed, 15 Jun 2005 11:52:58 -0700
To: 'Rotary motors in aircraft' <flyrotary@lancaironline.net>
Kevin asked:
> 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"

If in EXCEL  
Col-A/Row-1 =   -7719420,3871104
Col-B/Row-2 =   =LEFT(A1, SEARCH(",",A1)-1)/100000
Col-C/Row-3 =   =RIGHT(A1,LEN(A1)-SEARCH(",",A1))/100000

The result is:
       A              B           C
-7719420,3871104 -77.1942 38.71104

Hope that helps...will consult for flying time ;-)
Joe Hull
Bellevue (Seattle), Washington
Cozy MkIV #991 (working on Engine & Electrical & Finishing)
http://www.maddyhome.com/canardpages/pages/JoeHull/index.html
 

Subscribe (FEED) Subscribe (DIGEST) Subscribe (INDEX) Unsubscribe Mail to Listmaster