|
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:
- 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.
----- Original Message -----
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...
|