Addresses To Columns
 

I have a mail listing in Excel 2000 that needs to be converted to
table format.

1. The addresses are seperated by one or two returns, start on row 1
and have no labels listed.

2. Most addresses are listed as:

Mr. and Mrs. Doe
1234 Mesquite Drive
Whatever, OH 12345

3. Though some have company names:

Mr. and Mrs. Doe
Their Company
1234 Mesquite Drive
Whatever, OH 12345

**I would like to break up the data into these columns:

Company
Full Name
Street Address
City
State
Zip

I appreciate any help. Thanks in advance.

-Adria