[AmyMill]

My Sub List is getting too big for the Word table that I now have it in....it is so big that it locks up every time I try to open it. Is there a way that I can transfer the List to Excel (so that I don't have to retype)? We use Windows XP.

 

[flixx]

To AmyMill:
If you wish to move tabular data from Word to Excel. If the columns in the Word document are in a table, click in the table, choose Table | Select | Table from the menu, press Ctrl+C to copy to the clipboard, switch to Excel, and press Ctrl+V to paste it in. If items in the columns are separated by single tabs, again you can simply copy the lines representing the table to the clipboard and paste them into Excel.
If the columns in the Word document are aligned using spaces, a bit more effort is required. Highlight the columnar data in Word and copy it to the clipboard. Click in cell A1 of a blank worksheet in Excel and paste the data—you'll find that it all winds up in column A. With the data still selected, choose Text to Columns from the Data menu. On the first page, select Delimited and click on Next. On the second page, check only Space in the set of available delimiters. Make sure the Treat consecutive delimiters as one box is checked. Click on the Finish button and you're done. Hope this helps, Flixx.