If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to completely remove table but leave data
I have a .doc which was created from an excel mailing list. It
is setup for labels and is in 3 columns (30 to a page). I want to export this to a text format I can then import into excel again. (I don't have the original excel document and I want to join this info with other similar info [names and addresses]. I have looked all over and I can't figure out how to get rid of the table formatting but leave the data hopefully in a format that excel can easily import. Since is to remain essentially a mailing list, the info will change in the future as people move. I am fairly sure I use Data and Import in excel but I can't figure how to get the word document into a text delimited file. Any help??? Thanks |
#2
|
|||
|
|||
how to completely remove table but leave data
Exact menu option depends on version, but Table Convert Table to Text is
what you want -- Enjoy, Tony "J Mac" wrote in message ... I have a .doc which was created from an excel mailing list. It is setup for labels and is in 3 columns (30 to a page). I want to export this to a text format I can then import into excel again. (I don't have the original excel document and I want to join this info with other similar info [names and addresses]. I have looked all over and I can't figure out how to get rid of the table formatting but leave the data hopefully in a format that excel can easily import. Since is to remain essentially a mailing list, the info will change in the future as people move. I am fairly sure I use Data and Import in excel but I can't figure how to get the word document into a text delimited file. Any help??? Thanks |
#3
|
|||
|
|||
how to completely remove table but leave data
As Tony says, you want to start with Table | Convert | Table to Text. But
see http://www.word.mvps.org/FAQs/MailMe...ToDatafile.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "J Mac" wrote in message ... I have a .doc which was created from an excel mailing list. It is setup for labels and is in 3 columns (30 to a page). I want to export this to a text format I can then import into excel again. (I don't have the original excel document and I want to join this info with other similar info [names and addresses]. I have looked all over and I can't figure out how to get rid of the table formatting but leave the data hopefully in a format that excel can easily import. Since is to remain essentially a mailing list, the info will change in the future as people move. I am fairly sure I use Data and Import in excel but I can't figure how to get the word document into a text delimited file. Any help??? Thanks |
#4
|
|||
|
|||
how to completely remove table but leave data
GREAT info!!! Thanks!!!
"Suzanne S. Barnhill" wrote in message ... As Tony says, you want to start with Table | Convert | Table to Text. But see http://www.word.mvps.org/FAQs/MailMe...ToDatafile.htm |
#5
|
|||
|
|||
how to completely remove table but leave data
Great! Thanks!
"Tony Jollans" No Mail wrote in message ... Exact menu option depends on version, but Table Convert Table to Text is what you want |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
Help with relationship plase | Rock | General Discussion | 5 | July 4th, 2005 03:54 AM |
Help with relationship plase | Rock | Database Design | 5 | July 4th, 2005 03:54 AM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |