S
Simple
Is it possible to import a text file into Excel? I have a text file with
thousands of company names and address on (all formatted as below) that I
would like to import into Excel...problem is that I want to import them into
rows with each address detail falling under the correct column heading i.e.
Column for Company name, column for Address1 column for address 2 etc.
Company Name
Address
Address2
City
Postal Code
Company Name
Address
Address2
City
Postal Code
etc etc
Ultimately I need to use these address's to mail merge, otherwise if
somebody has a better suggestion for using a text file to mail merge with MS
Word I'm more than happy to listen.
Thanks
Si
thousands of company names and address on (all formatted as below) that I
would like to import into Excel...problem is that I want to import them into
rows with each address detail falling under the correct column heading i.e.
Column for Company name, column for Address1 column for address 2 etc.
Company Name
Address
Address2
City
Postal Code
Company Name
Address
Address2
City
Postal Code
etc etc
Ultimately I need to use these address's to mail merge, otherwise if
somebody has a better suggestion for using a text file to mail merge with MS
Word I'm more than happy to listen.
Thanks
Si