I am trying to make a contact list using excel. I have been entering
addresses of business' into excel in the following format:

ABC Company
123 Booton Rd
Beverly Hills, CA 90210
Phone: (555) 555-5555
Fax: (555)444-4444

I currently have over 20,000 business names in one single column and I was
wondering if there was a way that I can convert those addresses into seperate
rows separating them by: Name---Address---Phone #----Fax # without having to
copy and paste them or type them in individually

Try the vertical to horizontal:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"vdemar" <(E-Mail Removed)> wrote in message
news16B6E92-DF12-4855-A66D-(E-Mail Removed)...
> I am trying to make a contact list using excel. I have been entering
> addresses of business' into excel in the following format:
>
> ABC Company
> 123 Booton Rd
> Beverly Hills, CA 90210
> Phone: (555) 555-5555
> Fax: (555)444-4444
>
> I currently have over 20,000 business names in one single column and I was
> wondering if there was a way that I can convert those addresses into
seperate
> rows separating them by: Name---Address---Phone #----Fax # without having
to
> copy and paste them or type them in individually

That explanation doesnt really explain to you what to do

What is the problem? I will translate the steps to suit your 5-line
addresses.

Create three "sets". A set is the formula, and the corresponding blank rows
that follow it.

In C1, put =A1.
In D1, put =A2.
In E1, put =A3.
In F1, put =A4
In G1, put =A5

In C7, put =A7
In D7, put =A8
In E7, put =A9
In F7, put =A10
In G7, put =A11

In C13, put =A12
In D13, put =A13
In E13, put =A14
In F13, put =A15
In G13, put =A16

We make 3 sets, and select them.

You will select cells C1 through G17.

From here, we copy down. DO NOT STOP dragging until you've copied all the
way down. If you do, your "set" becomes however many cells are selected at
the time you begin dragging again.

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"vdemar" <(E-Mail Removed)> wrote in message
news2F80FD5-1E89-45C2-A999-(E-Mail Removed)...
> That explanation doesnt really explain to you what to do
>
>

I just cant seem to get it working, I think I may have too many addresses or
something. I think I've given up on it, I'm getting too frustrated but
thanks for your help.

What if some addresses have more or less then 5 lines??

It depends.

Are the addresses grouped (maybe separated by an empty row??)

If one of the lines is missing, is it always the same?

If you're missing one of the lines, is there anyway to determine which one is
missing?

vdemar wrote:
>
> What if some addresses have more or less then 5 lines??

--

Dave Peterson

There is always only one line in between the addresses...Its just that some
of the addresses have multiple phone numbers

Fax or Voice or either/both?

Do all the phone lines start with Phone or Fax?

You want to post a few (10 or 20 groups of addresses) that look like they're
typical--and include a few of the worst.



vdemar wrote:
>
> There is always only one line in between the addresses...Its just that some
> of the addresses have multiple phone numbers

--

Dave Peterson