Word Table into Excel

S

sandy2004

When I copy a row of text (divided into a number of columns) from a wor
table and paste in Excel - it copies down all information from acros
the columns down into ONE column (col A) instead of across int
seperate columns. Is there any way I can copy over details from
table in word to cells into Excel without writing VB
 
A

A

you can create a table in Word that is the same size as
the excel information that you are trying to move and
then simply copy and paste (when pasting make sure that
you highlight the entire table though.)
 
P

Paul Falla

Dear Sandy

In Word, move your cursor over the top left corner of your
table until you see a 4-way arrow appear. Click on this
arrow to select the entire table, copy the table. Move to
Excel and right mouse click in the cell where you want the
table to start and click paste. You should now have all
you table information in Excel in the same layout as your
Word table.

Hope this helps

Paul Falla
 
Top