Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Convert Word address list to Excel
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? |
#2
|
|||
|
|||
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. "Mluera" wrote: 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? |
#3
|
|||
|
|||
Meredith? Are you still around here?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create price list from excel sheet | Excel Discussion (Misc queries) | |||
how do i convert MS Word mailing labels into an Excel mailing lis. | Excel Discussion (Misc queries) | |||
Is there a way to create a drop-down list of links in Excel? | Excel Worksheet Functions | |||
Getting specific data from a word document into an excel sheet | Excel Worksheet Functions | |||
most effective way to link ms word tables to excel | Excel Discussion (Misc queries) |