Inserting line breaks into merged text cells.

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.

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


"MrSafetyNeedshelp" <[email protected]> wrote in
message news:[email protected]...
> 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.