A
Adria Draughn
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
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