Word Table into Excel

  • Thread starter Thread starter sandy2004
  • Start date Start date
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
 
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.)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Transfering one cell of word to excel 2
Copy and Paste cells limitation 4
CONVERTING MS WORD FORMATTED DATA INTO EXCEL WORKSHEET 3
Can I copy a table from Word into one cell in Excel without losing data? (Office 97) 2
Copying a table from Word 5
copying/pasting accurately from a Word table (carriage returns) 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top