M
Mike M
I have received about 40 separate 1-page MS Word docs,
that are essentially tables, but manually created with
newspaper-style columns.
All of the entries are 1 line long, so you will have line
one in column 1 corresponding to line one in columns 2 &
3. There are approximately 35-50 lines per page. The
person who created these didn't even know about column
breaks so they just wrapped the next column to the top
with hard-returns, but I can fix that and align the
columns easily enough. However, once I do that, is there
a reasonable way to convert these 3 columns into a table
format without having to copy and paste each line of data
separately? I have tried the "convert text to table"
feature (set to 3 columns, auto-fit) but it just makes one
HUGE column, and where the paragraph marks were there is a
little square symbol in the text.
Perhaps I'm missing a setting. Perhaps I need to create
the table then copy & move the columns into the table one
at a time (tried that, but It just put each column into
one cell rather than individual lines).
When this is done, I'd like to combine all of the ~40
separate tables into one master table, and then get it
into Excel. If I can get to that point I'll write again
if I need more help. But any suggestions getting there
would be GREATLY appreciated.
Oh, if this has been asked previously my apologies, but
there were about 1500 pages of questions to browse through
on the MS site (Word general help / newbie help /
formatting help) and after about 20 min of browsing I
decided it would just be easier to ask and risk asking a
question that's come up before.
Mike
that are essentially tables, but manually created with
newspaper-style columns.
All of the entries are 1 line long, so you will have line
one in column 1 corresponding to line one in columns 2 &
3. There are approximately 35-50 lines per page. The
person who created these didn't even know about column
breaks so they just wrapped the next column to the top
with hard-returns, but I can fix that and align the
columns easily enough. However, once I do that, is there
a reasonable way to convert these 3 columns into a table
format without having to copy and paste each line of data
separately? I have tried the "convert text to table"
feature (set to 3 columns, auto-fit) but it just makes one
HUGE column, and where the paragraph marks were there is a
little square symbol in the text.
Perhaps I'm missing a setting. Perhaps I need to create
the table then copy & move the columns into the table one
at a time (tried that, but It just put each column into
one cell rather than individual lines).
When this is done, I'd like to combine all of the ~40
separate tables into one master table, and then get it
into Excel. If I can get to that point I'll write again
if I need more help. But any suggestions getting there
would be GREATLY appreciated.
Oh, if this has been asked previously my apologies, but
there were about 1500 pages of questions to browse through
on the MS site (Word general help / newbie help /
formatting help) and after about 20 min of browsing I
decided it would just be easier to ask and risk asking a
question that's come up before.
Mike