Word 2010 > Excel 2010 Address import question

[bmooney]

Word > Excel 2010 question

so I have a document that lists names and addresses like this:
Bob Smith
2010 Main Street
BR, LA 70808
and I want to create an excel document with columns like Name, address, city, state, zip
but I cant just import it into excel the way it is or it all goes into 1 cell
how can I select each piece individually and give it its own field​

 

[Trevor G]

Welcome to the Forum. 2 suggestions.

1 Convert the address into a table and then ensure you split it down so each line has its own row. Then you have a start point for coping over to Excel

2 Place all the address into Contacts in Outlook then you can use the Export Option and can match the fields you want and delete the ones you don't need that will give you the look for what you want into Excel.

 

[bmooney]

Thanks, Trevor! FANTASTIC reply! Problem solved!

Welcome to the Forum. 2 suggestions.

1 Convert the address into a table and then ensure you split it down so each line has its own row. Then you have a start point for coping over to Excel

2 Place all the address into Contacts in Outlook then you can use the Export Option and can match the fields you want and delete the ones you don't need that will give you the look for what you want into Excel.

 

[Trevor G]

Glad it helped find a solution for you and thanks for letting me know.

 

[jimrward]

In the word document do you have a blank line between addresses, if so you could try the following to give you a head start in creating columns of data

1) using search and replace, look for ^p^p and replace with ~
2) again using search and replace look for single new line ^p and replace with ^t
3) finally use search and replace to look for ~ and replace with ^p

You should now hopefully have data items separated by tabs which you can convert to a table, or save as a text file this can then be imported into excel, or select the data from top to bottom and paste into excel then use text to columns with tab as the delimiter

NOTE not all data will be in correct columns you will have to do some editing in excel