New Line code in formula

[PaulS]

Question to the expert,
I have an addresslist with name(colB), street(colC), zip(colD, town(colE).
I want all data in one cell in another sheet, from where I will print addresslabels.
The cells in sheet Labels are just the right size for the labels to be printed.
In sheet 'Labels' cel B2 is:
=Address!B2&xx&Address!C2&xxAddress!D2&Address!E2
What char has to replace the xx in the formula so skip to a new line?
Thanks,
Paul

 

[CWatts]

Char(10)

Just make sure Wrap Text is enabled.