Excel 2007 : Trying to work out a spacing issue

I have a sheet full of contact information similar to a mailing list. All of the information is in rows. I am trying to create labels (I am aware of mailmerge, but that won't do exactly what I need) in a new sheet. But when I do this, copy and paste the label so that I have several on one sheet, it skips several contacts.

So on one sheet I have: First | Last | Address | Phone | Emergency Contact | ETC
But on the labels I am trying to do:
First Last
Address
Phone
Emergency Contact
etc etc

But when I copy this down the page, it will skip from the contact in row 2 to the contact in row 12, then 22, etc. Is there anyway to easily solve this problem?

Thanks for the help in advance.

Originally Posted by oldchippy

Hi,

Try this in H1, then format the cell to wrap text

=A1&" "&B1&CHAR(10)&C1&CHAR(10)&D1&CHAR(10)&E1

Thanks, that would work IF I didn't make everything so complicated. I need to format some of the cells etc. The name needs to be larger and bolder, and I am inserting some other form type information onto each label.

I've been looking all over and can't find a solution to this.