[Ham-Computers] RE: importing to excel

[Hsu, Aaron (NBC Universal)]

Don,

If the data in Word is already in some sort of "tabular" form (a table or
delimiter seperated), then importing into Excel should not be a problem.  If
the data is in a Word table, then you can directly copy and paste the table
into Excel and it will transform the table entries to cells.  If the data is
delimited (such as commas or tabs), you can convert the data to a table
using the "text to table" tool and then copy-n-paste to Excel.  Or, you can
delete everything in the document except the data to be imported, save the
data as a text only file, then import it to Excel by specifying that you
want to open a .TXT file and selecting the file.  It will then automatically
bring up the text import wizard and ask you how you want the data imported.
Above all else, the data needs to be in some recognizable format for Excel
to import it properly - the best "text" format for this purpose is "tab" or
"comma" delimited (fields seperated by tabs or commas)

BTW, I'm not a Word or Excel "power-user", so there may be an easier way to
do this.  These just happen to be way I would to it.

73,

  - Aaron, NN6O


-----Original Message-----
From: ham-computers-bounces at mailman.qth.net
[mailto:ham-computers-bounces at mailman.qth.net] On Behalf Of Don
Sent: Monday, July 04, 2005 8:51 AM
To: Ham-Computers
Subject: [Ham-Computers] importing to excel


HI the group

I have office 2000 on my puter
excel and word work great

NOW
can I import to excel numbers from word 

say a Lat/Long of 30.32N and 88.53W  or will i have to import them manually
into the cells i want in excel

if not clear i will answer ???


Don
SEMPER VIGILIS
DUTY, HONOR, COUNTRY
http://www.jcmsara.org Ham radio link http://myweb.cableone.net/wxfreqrs/
Pascagoula Ms Real Time Observations