Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
WORD 2000 pages layout when EXCEL table inserted | Page Layout | |||
Linking Excel data to tables in Word | Tables | |||
Autofit table in Word 2002 with cut and paste from Excel | Tables | |||
Table link to Excel | Tables |