How can transfer a Word table file into Excel – I am a software idiot?
Good news – bad news. You can very easily copy this to Excel, however, if you have firstname lastname in Word, it will transfer with firstname lastname in the same cell in Excel. One of the first things we are taught in learning Excel is to keep some columns/fields of information in separate columns like firstname—–lastname—–address—-… Then, you can sort in any number of ways, and for a bulk mailing, you can sort by zip. **************************** To put your Word table into Excel: 1. Open a new Excel workbook. 2. Give it an appropriate name. 3. Go to your Word table 4. Select the table 5. right-click and “copy” 6. Open the Excel file 7. In call A1, cl Edit, Paste 8. Immediately, save this database. Now, you still have firstname lastname in one column. click the second column heading this should select the whole column click Insert, Column (this should give you a blank column next to the names) Now, you will have to go down the list, one by one, and select the lastname right-
