Excel address import?

[Xee]

Hi, I have a long MS Word document with lots of addresses (each address on one line). I would like to get these addresses into excel with each part of the address in the correct column. ie.

NAME | ADDRESS 1 | ADDRESS 2 | CITY | POSTCODE (etc.)

Is it possible to do this in any other way, other then copy pasting each bit one at a time, as its going to take me forever... and ever

Only thing that I have found is this but it is not free: http://www.office-addins.com/-excel-addins/address-assistant.html

Any clever clogs out there?

 

[|Ric|]

copy data into notepad, save, then in excel file->open the txt file

This works assuming the data is in the format:
Name, Address 1, Address 2, ...
i.e. there is some character delimiting the bits that form columns

If you are missing a line as well it will be out of place, i.e. no address 2

Ric.

 

[Xee]

Thank you Works great!