# Need help

=?Utf-8?B?dmRlbWFy?=
Guest
Posts: n/a

 8th Jul 2005
I am trying to make a contact list using excel. I have been entering

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

Anne Troy
Guest
Posts: n/a

 8th Jul 2005
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
>
> 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

=?Utf-8?B?dmRlbWFy?=
Guest
Posts: n/a

 8th Jul 2005
That explanation doesnt really explain to you what to do

Anne Troy
Guest
Posts: n/a

 8th Jul 2005
What is the problem? I will translate the steps to suit your 5-line

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

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
>
>

=?Utf-8?B?dmRlbWFy?=
Guest
Posts: n/a

 8th Jul 2005
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

=?Utf-8?B?dmRlbWFy?=
Guest
Posts: n/a

 8th Jul 2005

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

Dave Peterson
Guest
Posts: n/a

 8th Jul 2005
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

=?Utf-8?B?dmRlbWFy?=
Guest
Posts: n/a

 8th Jul 2005

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

Dave Peterson
Guest
Posts: n/a

 8th Jul 2005
Fax or Voice or either/both?

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

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?RGVubmlz?= Microsoft Excel New Users 1 12th Mar 2007 09:53 PM Jonathan Windows XP General 10 13th Jan 2005 03:22 AM =?Utf-8?B?U2FuYXRhcml1bV83?= Windows XP General 2 25th Sep 2004 04:00 PM -\$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM Marcello do Guzman Microsoft Excel Programming 2 9th Dec 2003 06:30 PM

Features