View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Majestic Glory Majestic Glory is offline
external usenet poster
 
Posts: 1
Default extracting data from one format to a different format...

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


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.