Using concatenate to create a new line

[smithgt]

When editign a single cell you can press ALT+ENTER to use the second line within a cell. I find this quite useful for entering postal address. e.g.

Name Alt+Enter
Address Alt+Enter
Town Alt+Enter

etc

Is there a way to use CONCATENATE to apply "Alt+Enter" in a new cell where data is cuttently in several cells?
Thanks

[DonkeyOte]

You can use CHAR(10) ... you will need to ensure cell is formatted for Wrap Text.

either

=A1&CHAR(10)&B1&CHAR(10)&C1

or

=CONCATENATE(A1,CHAR(10),B1,CHAR(10),C1)

[SamuelT]

Hi there,

Something like this would work:

="Joe Bloggs"&CHAR(10)&"100 Nowhere Street"&CHAR(10)&"Nowhereville"

Be sure to wrap the text otherwise you'll get a little box with a question mark in it where there's supposed to be line breaks. Obviously you can use cell reference instead of hard-coded text if desired.

HTH,

SamuelT