Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Kenny Kepler
 
Posts: n/a
Default Export table data to Excel

Hi,

I have a table in word made up of two columns and about 50 rows; so about
100 cells. This table is used to enter contact details, e.g. contact name,
company name, address, etc. Now I wouldn't have chosen to do this myself,
but I inherited this document from my predecessor. I want to get the data in
each cell to be exported to Excel as a row. This would enable me to sort
the data better and it can also be used as mail merge source. I have found
some duplicate names and want to delete them, but if I sort the table so
that I can more easily spot them, it doesn't change the order at all. In
Excel this would be much easier. I suspect whoever created this doc used
sized the cells to print on labels, but of course mail merge does that
better.

So does anyone know how I can get a cell of data copied to row in an Excel
spreadsheet?

TIA

Kenny


 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM
WORD 2000 pages layout when EXCEL table inserted Quetzalcoatl Page Layout 0 January 4th 05 10:13 PM
Linking Excel data to tables in Word KSit Tables 3 November 26th 04 09:36 PM
Autofit table in Word 2002 with cut and paste from Excel Mark Tables 1 November 17th 04 02:13 PM
Table link to Excel Eric L. Tables 0 October 28th 04 06:35 PM


All times are GMT +1. The time now is 09:53 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"