OfficeFrustration - View Single Post - extracting data from one format to a different format...

**Ron Rosenfeld** · May 30th, 2010, 03:02 AM posted to microsoft.public.excel.misc

On Sat, 29 May 2010 17:07:01 -0700, Majestic Glory Majestic
wrote:

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.

You need to provide more information.

1. In your header, you have two Address columns (Address1 and Address2) but in
your example you have only a single address line. Does this mean that some
entries have seven lines and others eight? What about those without a Fax? Or
those without and Email? Are there blank lines or no lines?

2. How do you tell when you go from one company to the next?

3. Are there any other variations you haven't mentioned?
--ron