X-Virus-Scanned: clean according to Sophos on Logan.com Return-Path: Received: from a34-mta02.direcway.com ([66.82.4.91] verified) by logan.com (CommuniGate Pro SMTP 4.3.4) with ESMTP id 1003363 for flyrotary@lancaironline.net; Wed, 15 Jun 2005 16:28:02 -0400 Received-SPF: none receiver=logan.com; client-ip=66.82.4.91; envelope-from=jackbeale@direcpc.com Received: from jack (dpc691916001.direcpc.com [69.19.16.1]) by a34-mta02.direcway.com (iPlanet Messaging Server 5.2 HotFix 1.25 (built Mar 3 2004)) with SMTP id <0II500G0A7H2PV@a34-mta02.direcway.com> for flyrotary@lancaironline.net; Wed, 15 Jun 2005 16:27:11 -0400 (EDT) Date: Wed, 15 Jun 2005 16:26:37 -0400 From: Jack Beale Subject: Re: [FlyRotary] non-rotary question on spreadsheets To: Rotary motors in aircraft Message-id: <006501c571e8$a20316f0$2619050a@jack> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Mailer: Microsoft Outlook Express 6.00.2600.0000 Content-type: multipart/alternative; boundary="Boundary_(ID_AbyC0aqJqoAzLXeKMaVkfw)" X-Priority: 3 X-MSMail-priority: Normal References: This is a multi-part message in MIME format. --Boundary_(ID_AbyC0aqJqoAzLXeKMaVkfw) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT K, If indeed, Quatro Pro works just as Excel, this is an easy fix - I just tried it in Excel You will not need to program any "string" functions or other gyrations. There is already a built-in function to do what you want. Here's how: a.. Paste the latitude and longitude data you want to convert to two cells into a spreadsheet. b.. Highlight the column of data you'd like to work on. c.. Select "Data" (this is what it's called in Excel) from the toolbar. d.. Select "Text to Columns", and a window will open. e.. Select "Delimited" and click "Next". f.. In the next window, put a check-mark next to "Comma". g.. Click "Next", then "Finish". h.. You're done and have two columns, with one number in the first and the other in the second..... i.. You can simply divide each number by 10,000 to get the decimal in the right location. I believe that Quatro can be set to utilize the Excel menus and commands. Jack Beale jack.beale (at) att.net -------------------------------------------------------------------------------- ----- Original Message ----- From: kevin lane To: Rotary motors in aircraft Sent: Wednesday, June 15, 2005 2:06 PM Subject: [FlyRotary] non-rotary question on spreadsheets 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. 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... Kevin Lane Portland, OR e-mail-> n3773@comcast.net --Boundary_(ID_AbyC0aqJqoAzLXeKMaVkfw) Content-type: text/html; charset=iso-8859-1 Content-transfer-encoding: 7BIT

If indeed, Quatro Pro works just as Excel, this is an easy fix - I just tried it in Excel

You will not need to program any "string" functions or other gyrations. There is already a built-in function to do what you want.

Here's how:

Paste the latitude and longitude data you want to convert to two cells into a spreadsheet.
Highlight the column of data you'd like to work on.
Select "Data" (this is what it's called in Excel) from the toolbar.
Select "Text to Columns", and a window will open.
Select "Delimited" and click "Next".
In the next window, put a check-mark next to "Comma".
Click "Next", then "Finish".
You're done and have two columns, with one number in the first and the other in the second.....
You can simply divide each number by 10,000 to get the decimal in the right location.

I believe that Quatro can be set to utilize the Excel menus and commands.

Jack Beale
jack.beale (at) att.net

----- Original Message -----

From: kevin lane

To: Rotary motors in aircraft

Sent: Wednesday, June 15, 2005 2:06 PM

Subject: [FlyRotary] non-rotary question on spreadsheets

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.

    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...

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

--Boundary_(ID_AbyC0aqJqoAzLXeKMaVkfw)--