Convert Word address list to Excel

[Guest]

I'm trying to convert an old address list written in word into an excel
spreadsheet.. The addresses are basic 3 lines (name, address, city, state,
zip). Other than copying each item into each cell individually, is there a
way to do this more efficiently?

 

[Guest]

If each line of the list is ended with a hard return, then replace each hard
return with a tab. Use the Replace All function. Once the whole list is
tabbed, highlight the text, click on Table, then Convert text to table. Make
sure you pick "Separate text at Tabs". Then clean up your table. Once it is
in a good condition, select the whole table and paste it into an Excel
spreadsheet.

Make sure you copy the original list to a new document first before doing
the replace function. This way your list will still be intact. Hope this
helps.

 

[HarrisAssoc101]

Harris

Meredith?