Mailing list formula

[EarHalo]

I am addiny in a mailing list and do not know what formula to add them together, But on sepearate lines.

When I add A2&B2 I get it all on one line like Company, Address, Zip...

I want it to come out like :

Company
Address
Zip

Or is there a better way to add a mailing list to excel...

SO I know that the mailing labels with fit the right format of the excel file... Confused...

Please help... Need advice

Jason

[VBA Noob]

Maybe

=A2&CHAR(10)&B2

then format the cell > alignment > wrap

VBA Noob

[EarHalo]

I tried that. However, It seems to wrap it but only depending on how wide the column is. Is this right? Cause each name is a different ammount of letters. If I am doing this correct.

What I need tis for every column to be on a seperate line.

I tried the A2&CHAR(10)&B2 but was unsure what the CHAR(10) stood for. Maybe you can explain... lol... Man am I confused.

The columns I am using are A, B, C, D let me know what the code would look like if possible...

Or if anyone knows even how to print the labels when I am done. And which labels do I need to use.

Please help...

Thanks in Advance.

JAson

[VBA Noob]

The char(10) mimic's a carriage return

See example

VBA Noob

[EarHalo]

Okay.. I got it.. thanks sop much...

Now, Does anyone know how to print the labels from here? Do I need to import into another program? or does excel print labels?

This will be my LAST question... lol

Thanks in advance,

Jason