Pasting Word table into Excel 2000

  • Thread starter Thread starter Michael22
  • Start date Start date
M

Michael22

When I copy a table from Word 2002 and paste it into Excel 2000
for some reason each row in the table ends up occupying two rows i
Excel. How can I get the table to paste properly
 
-----Original Message-----
When I copy a table from Word 2002 and paste it into Excel 2000
for some reason each row in the table ends up occupying two rows in
Excel. How can I get the table to paste properly?


---
Message posted

.
Is the data really in two rows or are the row heighs
Click to expand...
enlarged?.

If the row height changed highlight the effected rows and
select Format, Row, Height and enter 12.75. or select
format, row, auto fit.
 
The following advice from Dave Peterson may help:

'===========================================
Inside Word, select the table and do two Edit|Replaces.
First one replaces paragraph mark (^p) with a unique string ($$$)
second one replaces manual line break (^l) (lowercase ELL) with $$$

Then copy the table and paste into Excel.

then do an Edit|Replace within excel.
Replace $$$
with hit and hold the alt-key and type 0010 from the number pad
(It may look like nothing was entered, but try it.)

alt-0010 is the same as the alt-enter to wrap to a new line in an excel
cell.

Don't forget to close the word document without saving.
'=======================================================
 
Back
Top