1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel address import?

Discussion in 'Windows & Other Software' started by Xee, 10 Jul 2006.

  1. Xee

    Wise Guy

    Joined: 13 Jun 2003

    Posts: 1,184

    Location: In front of PC

    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? :)
     
  2. |Ric|

    Hitman

    Joined: 28 Jun 2005

    Posts: 895

    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.
     
  3. Xee

    Wise Guy

    Joined: 13 Jun 2003

    Posts: 1,184

    Location: In front of PC

    Thank you ;) Works great!