[vicsireland] Re: MSWord Question
- From: "Sandberg, Robert" <robert.sandberg@xxxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Fri, 9 Jun 2006 16:16:02 +0200
OK, here is what I think is the simplest way, which of course occurred
to me only after I suggested using programming code. Fool!
If there is text around the table, select the table and paste into an
empty Word document.
From the table menu select convert table to text.
In the following dialog field you can select a separator. Check others
and put a comma in the edit field, then press enter.
Now save. In the save file dialog, select plain text and type the file
name with extension .csv.
Cheers,
Robbie
--Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Tony Murray
Sent: Mittwoch, 7. Juni 2006 15:20
To: VICS
Subject: [vicsireland] MSWord Question
Hi VICSonians,
I've a table in MSWord, which I want to export to a CSV file. CSV
(Comma
Separated Value) files are just flat text files delimited by commas.
Now,
if I can get it in to MS Excel, I can save it out as a CSV so that'll
do.
Does anyone know of a way of getting my table from MSWord in to MSExcel?
If not that, does anyone know of a way of converting the MSWord table in
to
a CSV?
I don't fancy manually copying and pasting each cell... The table is
massive!
It's ironic really... I've been given an 83 page functional spec, and
all I
need is this one table. Someone actually went to the bother of pulling
the
contents of a table from the Mainframe and converting it in to MSWord as
part of the spec. Now I want to take it back out of Word and make it in
to
flat text... which is the format it would've come from the Mainframe in
originally.
Am I rambling? Yes. The Sun is having some weird effects on me. It's
making me want to drink beer on Wednesdays, and forget work.
Can anyone help me?
Tony
"If something is too hard to do, then it's not worth doing. You just
stick
that guitar in the closet next to your shortwave radio, your karate
outfit
and your unicycle and we'll go inside and watch TV."
--Homer J. Simpson
************************************************************************
********
This document is strictly confidential and is intended for use by
the addressee unless otherwise indicated.
This email has been scanned by an external Email Security System.
Allied Irish Banks
************************************************************************
********
Other related posts: