[Ham-Computers] RE: importing to excel
Don
wxfreqrs at cableone.net
Wed Jul 6 22:30:03 EDT 2005
thanks Aaron
i think this will work
Don
SEMPER VIGILIS
DUTY, HONOR, COUNTRY
http://www.jcmsara.org Ham radio link
http://myweb.cableone.net/wxfreqrs/ Pascagoula Ms Real Time Observations
----- Original Message -----
From: "Hsu, Aaron (NBC Universal)" <aaron.hsu at nbcuni.com>
To: "'I>Ham-Computers'" <Ham-Computers at mailman.qth.net>
Cc: <wxfreqrs at cableone.net>
Sent: Wednesday, July 06, 2005 8:07 PM
Subject: [Ham-Computers] RE: importing to excel
> 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
> _______________________________________________
> Ham-Computers mailing list
> Ham-Computers at mailman.qth.net
> http://mailman.qth.net/mailman/listinfo/ham-computers
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.8.9/42 - Release Date: 7/6/2005
>
>
More information about the Ham-Computers
mailing list