 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Long Documents / May 2006Converting 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 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.  SignatureSuzanne 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. > I have inherited a neighborhood roster of 409 properties in MS Word. > [quoted text clipped - 11 lines] > > Dennis I've never used a word table as a base for the directory. Will try it. Thanks, Dennis > Why do you need to get it into Excel? Use Table | Convert | Text to Table > to [quoted text clipped - 20 lines] >> >> Dennis 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/ExpressMailMerges.htm), when you click on the Open Data Source button on the Mail Merge toolbar. SignatureSuzanne 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. > I've never used a word table as a base for the directory. > [quoted text clipped - 26 lines] > >> > >> Dennis
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.