M
Majestic Glory
I have a large database of company contacts that is formatted/entered as
follows:
ABC Company, Inc.
John Doe
123 Main Street NE
Des Moines, IA 52000
Phone: 123-456-7890
Fax: 098-765-4321
(e-mail address removed)
Each line is in it's own cell, but I need it in column format such as follows:
Company Name - First Name - Last Name - Address1 - Address2 - City - State -
Zip - Phone - Fax - Email
Any direction as to how I can easily do this? I'm using either 2003 or 2007
and have over 7,000 entries like this. PLEASE HELP as I don't want to spend
hours into days trying to do this manually! Thanks.
follows:
ABC Company, Inc.
John Doe
123 Main Street NE
Des Moines, IA 52000
Phone: 123-456-7890
Fax: 098-765-4321
(e-mail address removed)
Each line is in it's own cell, but I need it in column format such as follows:
Company Name - First Name - Last Name - Address1 - Address2 - City - State -
Zip - Phone - Fax - Email
Any direction as to how I can easily do this? I'm using either 2003 or 2007
and have over 7,000 entries like this. PLEASE HELP as I don't want to spend
hours into days trying to do this manually! Thanks.