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
|
|||
|
|||
Converting Word to Excel
I have inherited a neighborhood roster of 409 properties in MS Word.
I need to get it into Excel to make a bookfold directory in word. I have manually placed each property on its own line with tabs between the fields i.e. name, address, telephone, etc.. I'm using Office2003 and have tried many ways to import it into excel, but to no avail. What would you suggest? Thanks, Dennis |
#2
|
|||
|
|||
Converting Word to Excel
Why do you need to get it into Excel? Use Table | Convert | Text to Table to
convert the tab-delimited text into a table. You can then copy/paste into Excel if you like, but you can equally well use the Word table as a mail merge data source. For only 409 properties, I'd be tempted to leave it in Word. -- 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. "Dennis Hughes" wrote in message ... I have inherited a neighborhood roster of 409 properties in MS Word. I need to get it into Excel to make a bookfold directory in word. I have manually placed each property on its own line with tabs between the fields i.e. name, address, telephone, etc.. I'm using Office2003 and have tried many ways to import it into excel, but to no avail. What would you suggest? Thanks, Dennis |
#3
|
|||
|
|||
Converting Word to Excel
I've never used a word table as a base for the directory.
Will try it. Thanks, Dennis "Suzanne S. Barnhill" wrote in message ... Why do you need to get it into Excel? Use Table | Convert | Text to Table to convert the tab-delimited text into a table. You can then copy/paste into Excel if you like, but you can equally well use the Word table as a mail merge data source. For only 409 properties, I'd be tempted to leave it in Word. -- 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. "Dennis Hughes" wrote in message ... I have inherited a neighborhood roster of 409 properties in MS Word. I need to get it into Excel to make a bookfold directory in word. I have manually placed each property on its own line with tabs between the fields i.e. name, address, telephone, etc.. I'm using Office2003 and have tried many ways to import it into excel, but to no avail. What would you suggest? Thanks, Dennis |
#4
|
|||
|
|||
Converting Word to Excel
If you have Word 2002 or 2003, create the table as a separate document. Put
your field names in the top row and mark it as a heading row. Then select this as your data source when you come to the appropriate point in the Wizard, or, if you're using the "express" method (see http://sbarnhill.mvps.org/WordFAQs/E...MailMerges.htm), when you click on the Open Data Source button on the Mail Merge toolbar. -- 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. "Dennis Hughes" wrote in message ... I've never used a word table as a base for the directory. Will try it. Thanks, Dennis "Suzanne S. Barnhill" wrote in message ... Why do you need to get it into Excel? Use Table | Convert | Text to Table to convert the tab-delimited text into a table. You can then copy/paste into Excel if you like, but you can equally well use the Word table as a mail merge data source. For only 409 properties, I'd be tempted to leave it in Word. -- 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. "Dennis Hughes" wrote in message ... I have inherited a neighborhood roster of 409 properties in MS Word. I need to get it into Excel to make a bookfold directory in word. I have manually placed each property on its own line with tabs between the fields i.e. name, address, telephone, etc.. I'm using Office2003 and have tried many ways to import it into excel, but to no avail. What would you suggest? Thanks, Dennis |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to put graphics on envelopes? | Steve Koenig | General Discussion | 20 | September 14th, 2007 04:40 PM |
Word should allow to 'divide' page by 3 or 4, not just 2 | CandasK | Page Layout | 2 | February 28th, 2006 10:16 PM |
Excel worksheet in Word linked text boxes | Eduardo Oliveira | Page Layout | 0 | January 5th, 2005 11:23 PM |
How to change merge forms from Word Perfect to Microsoft Word | Charles Kenyon | General Discussion | 1 | December 30th, 2004 03:35 PM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |