There were a few postings that had the directions for getting the directory into Excel format. I can't find them on Google. Does anyone remember the directions? They would be most appreciated.
Importing directory into Excel
Jul 31, 2003
1 Replies
Hi Alice I have Excel 2002. I opened up Excel and in the search boxed typed "table to excel" and found your answer. In case you have a different version, etc., I've cut and pasted the directions. It worked great for me so hope it works for you
Ann
Copy a Word table into Excel
1.. In Microsoft Word, select the rows and columns of the table you want to copy. If you want to select the entire table, click the table, point to Select on the Table menu, and then click Table. 2.. Click Copy on the Standard toolbar. 3.. Switch to your Microsoft Excel worksheet. 4.. Click in the upper-left corner of the worksheet area where you want to paste the table. Cells from the copied table replace any existing cells in the area. 5.. Click Paste . 6.. To adjust the formatting, click Paste Options next to the data, and then click Match Destination Formatting to use any formatting that was previously applied to the Excel cells, or Keep Source Formatting to match the formatting of the Word table as closely as possible. Note Excel pastes the contents of each cell in the Word table to a separate Excel cell. If you want to split the data in the cells further, for example to divide first and last names so they're in separate cells, use the Text to Columns command on the Data menu.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required