Home |
Search |
Today's Posts |
#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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to merge data into a table and keep it's contents in line | Mailmerge | |||
How do I consolidate multiple mail merge data files into one file | Mailmerge | |||
DotNet Data Table as Mail Merge Data Source | Mailmerge | |||
How do I insert Excel data as a Word table and stay within margins | Tables | |||
Remove Rows from a Table after merging | Mailmerge |