J
jpetrang
I need to know how to get information from a Word document into
an Excel spreadsheet. The following format is used in the Word doc:
[Label 1][Label 2] Arbitrary amount of text. May include paragraphs
or tables or graphics, or may be simply one sentence. [type 1][type 2]
[type 3]
There will be many repititions of that format. There may be as many
as ten labels before the text, and we don't know which of the ten, or
how many of them before a given text block. After the text block, the
types will also be from a predetermined set, but again there may be any
combination present. In Excel, I need a table starting with the 10
columns, a column for the text, then one column for each of the types.
Each of these repetitions will get one row in the Excel sheet.
How can this be done? I tried simply saving the Word doc as text,
opening Excel and importing the file, but it seems Excel insists that
each new line in the file gets a new row in Excel. That's not what I
need.
Does this require a VB script of some sort? Maybe to convert the Word
doc into a format that is friendlier to being imported into Excel? I
don't know any VB or any kind of Word or Excel scripting at all, but
as I am a software engineer, I'm not above learning if I'm pointed in
the right directions.
I could dust off my Perl skills, but I'm under the impression there's
a more direct way to do this, that doesn't require the user to have
a perl engine installed on their PC.
Thanks,
JeanneP
PS: The email address used to post is obsolete. Any email to it will
likely bounce.
an Excel spreadsheet. The following format is used in the Word doc:
[Label 1][Label 2] Arbitrary amount of text. May include paragraphs
or tables or graphics, or may be simply one sentence. [type 1][type 2]
[type 3]
There will be many repititions of that format. There may be as many
as ten labels before the text, and we don't know which of the ten, or
how many of them before a given text block. After the text block, the
types will also be from a predetermined set, but again there may be any
combination present. In Excel, I need a table starting with the 10
columns, a column for the text, then one column for each of the types.
Each of these repetitions will get one row in the Excel sheet.
How can this be done? I tried simply saving the Word doc as text,
opening Excel and importing the file, but it seems Excel insists that
each new line in the file gets a new row in Excel. That's not what I
need.
Does this require a VB script of some sort? Maybe to convert the Word
doc into a format that is friendlier to being imported into Excel? I
don't know any VB or any kind of Word or Excel scripting at all, but
as I am a software engineer, I'm not above learning if I'm pointed in
the right directions.
I could dust off my Perl skills, but I'm under the impression there's
a more direct way to do this, that doesn't require the user to have
a perl engine installed on their PC.
Thanks,
JeanneP
PS: The email address used to post is obsolete. Any email to it will
likely bounce.