Thanks for your time and thoughts on this Nick
What I am doing is trying to reformat a 'mailing list' that is layed
out in Excel in the manner I wrote about; so when trying to use it to
print labels, each cell grabs its own label. Not a good thingy! I
don't know why it was set up this way or even why it is in excel. I am
thinking that after I get it properly setup I may try my hand at
importing it into a table in access and doing the mailing thing from
the database app instead of the spreadsheet app.

Again, thanks for your interest. You guys are great.


NickHK wrote:

Joanne,
Personally, I would avoid combining this data into a single cell, because
that make checking, analysis and sorting much more difficult.
Why do you want all the info in a single cell ?

NickHK

"Joanne" wrote in message
...
I have a contact file in excel that has the data all in individual
cells and I need to get it into 3 lines of info per cell.

Here is the scenario

A1 John Doe
A2 110 Main Street
A3 Anytown, USA

I need to get into this format:
A1 John Doe
110 Main Street
Anytown, USA

A2 Jane Doe
110 Main Street
Anytown, USA

etc etc for approx 600 Contacts

I wanted to do a macro to get me started, but I don't know how to cut
and paste the information from the individual cells into one cell, so
I am stymied right from the get go. I am quite familiar with VBA in
MSWord 2003 and a bit with Outlook, but have no experience at all in
Excel.

Am using MSOffice Pro 2003 on WinXP Pro - the file consists of 3 line
addresses with one blank row in between each contact.

Any help or direction towards help will sure be appreciated.

Thanks
Joanne