Inserting line breaks into merged text cells.

[Guest]

Hi,

I have about 60000 mail recipiants on an excel list thats in the form of
a1,b1,c1,d1,e1,f1. Which is just the mailing address for 1 person.

Now I'm trying to get the row of cells into one cell so I can paste them
into labels in a word document. Avery 5163 to be exact. So i've been trying
to use concatenate(a1,b1,c1,d1,e1,f1) to make it into a mail form but I
can't figure out the command for line breaks. Can you add a line break to a
formula to add text?

If not.. does anyone have an answer? I'm using outdated software (Office
2000).

Thanks for your time.

 

[RagDyer]

Don't change anything!

Right now you have the *perfect* data set-up to use mail-merge in Word to
create your labels from this data in XL.

Maybe all you'll need to do is add column labels if your data *really*
starts in Row1.

Check out his web site of David McRitchie:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================