Reply
 
Thread Tools Display Modes
  #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


  #2   Report Post  
Genine
 
Posts: n/a
Default

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

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 6th 05 12:23 AM
WORD 2000 pages layout when EXCEL table inserted Quetzalcoatl Page Layout 0 January 4th 05 11:13 PM
Linking Excel data to tables in Word KSit Tables 3 November 26th 04 10:36 PM
Autofit table in Word 2002 with cut and paste from Excel Mark Tables 1 November 17th 04 03: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 05:25 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"