if I have used a excel sheet for an address book, Name, address, address1,
etc etc in the columns and the individual address' in the rows, is there any
way I can convert that to a list of all the different address' individually
???

Hi Pete,
I your intent is to print labels, you would use Microsoft Word with your
Excel sheet as the first sheet and used as the database.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Pete" wrote in message ...
if I have used a excel sheet for an address book, Name, address, address1,
etc etc in the columns and the individual address' in the rows, is there any
way I can convert that to a list of all the different address' individually
???

Pete

Sounds like each row is a separate person and address etc. but not sure.

That is the normal format if you are exporting to an address book or using in
a MailMerge with Word or similar.

What exactly do you want done with the list you now have?

Show us a small example, maybe 5 or 6 rows of data so's we can get a better
idea.


Gord Dibben Excel MVP

On Wed, 11 May 2005 14:44:12 -0700, "Pete"
wrote:

if I have used a excel sheet for an address book, Name, address, address1,
etc etc in the columns and the individual address' in the rows, is there any
way I can convert that to a list of all the different address' individually
???

Say I Have:

Name Address Address 1 Tel email
Peter 1 ding Place LA 3184748
pete@ding
George 17 My Road NYC 4756474
George@My

Can I get them to automatically go onto a page as follows, wihtout having to
type them all out again??:

Peter
1 ding place
LA
3184748
pete @ ding


George
17 My Road etc etc etc

yes, see my previous answer using Mail Merge, if you don't have Word
you can use the elephants are us example of John Walkenbach's in the
related area, but Mail Merge is best.

"pete" wrote in message ...

Say I Have:

Name Address Address 1 Tel email
Peter 1 ding Place LA 3184748 pete@ding
George 17 My Road NYC 4756474 George@My

Can I get them to automatically go onto a page as follows, wihtout having to
type them all out again??:

Peter
1 ding place
LA
3184748
pete @ ding


George
17 My Road etc etc etc