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?
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?
Works great!