X-Virus-Scanned: clean according to Sophos on Logan.com Return-Path: Received: from [216.211.128.10] (HELO mail-in02.adhost.com) by logan.com (CommuniGate Pro SMTP 4.3.4) with ESMTP id 1003148 for flyrotary@lancaironline.net; Wed, 15 Jun 2005 14:53:50 -0400 Received-SPF: none receiver=logan.com; client-ip=216.211.128.10; envelope-from=JoeH@PilgrimTech.com Received: from pilgrim9 (tide509.microsoft.com [131.107.0.79]) by mail-in02.adhost.com (Postfix) with ESMTP id 6ACF02BF216 for ; Wed, 15 Jun 2005 11:53:02 -0700 (PDT) (envelope-from JoeH@PilgrimTech.com) Reply-To: From: "Joe Hull" To: "'Rotary motors in aircraft'" Subject: RE: [FlyRotary] non-rotary question on spreadsheets Date: Wed, 15 Jun 2005 11:52:58 -0700 Organization: Pilgrim Technologies MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 thread-index: AcVx1NruUa78n5bKTl2IUm2zzPJO/wABeeCw X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 In-Reply-To: Message-Id: <20050615185302.6ACF02BF216@mail-in02.adhost.com> 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