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 |
#2
|
|||
|
|||
First of all, before you do anything to the table, replace the returns in
each labels with commas (replace ^p with ,) and then convert your data to text (table, convert table to text) using paragraphs. This will separate the data into strings with each line of the address separated by a comma. Save as a text file and close the document. Rename the text file as a CSV and open it in excel, then save it as an excel worksheet. You can still use an excel file as a data source for a word mail merge. Genine "Kenny Kepler" wrote: 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 |
Reply |
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 |