Importing directory into Excel

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.

Reply to
AliceW
Loading thread data ...

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.

Reply to
Ann

InspirePoint website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.