clean import from Word 2003 to Excel 2003

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Is there a way to get a clean, formatted transfer of Word tables to
Excel? What I've done is do a Word Save-as to Web (HTML), and then
import this into Excel.

However, I'm going blind working in Excel fixing small errors, such as
values that were togther in a single Word table cell being rendered as
two cells, and cell tint being lost completely, and cell orientation
and justification. I have to manually resize rows and columns. Is there
a tool for doing this conversion, or methods I can use to minimize or
eliminate these problems?
 
How about a partial solution that will fix any problem with pasting an MSWord
cell to multiple cells in excel?

Saved from a previous post:

If your cells in your word table contain paragraph mark or linebreak characters,
then excel will bring them over as separate cells.

One way around it is to convert those paragraph marks & linebreaks to unique
characters, then copy|paste and then convert them back to linefeeds.

I like this technique (inside a copy of the word file):
Select your table.
Edit|replace|Special (show More if required)
Find what: (paragraph mark under Special button)
replace with: $$$$$ (if $$$$$ doesn't appear in the table)
replace all

Same thing with Manual Line break (from under Special).

Now copy the table into Excel.

Edit|Replace
Replace what: $$$$$
Replace with: hit and hold the alt and type 0010 from the number pad--not above
QWERTY.

It may look like you haven't done anything, but if you did it right, you
replaced $$$$$ with alt-enter.
Replace all.

Don't forget to close the word document without saving (or hit undo as many
times as necessary).


=========
I've got no suggestions for the formatting problems.
 
Back
Top