paragraph breaks with concatenate

[michaelsmithgall]

question:
How can i add a paragraph mark in my concatenation so that i can show a cell with combine rows of data in the same row format rather than one large run on sentence.

If i have a series of information like this in collumn A

A1: Blue
A2: Green
A3: Yellow

when i try to concatenate (and assumeing i add spaces in) I would a cell that looks like this

B1: Blue Green Yellow

what i want is a cell that looks like this

B1 Blue
Green
Yellow

when i am typing a paragph i can use Alt/Enter to create the paragraph but not sure if or how to put a parapgrah break after a cell reference while concatenating.

any ideas?

 

[CWatts]

Yes, use CHAR(10)

="Line1"&CHAR(10)&"Line2"&CHAR(10)&"Line3"

Make sure wrap text is on or you'll get boxes where the new lines should be.

 

[edokhotnik]

question:
How can i add a paragraph mark in my concatenation so that i can show a cell with combine rows of data in the same row format rather than one large run on sentence.

If i have a series of information like this in collumn A

A1: Blue
A2: Green
A3: Yellow

when i try to concatenate (and assumeing i add spaces in) I would a cell that looks like this

B1: Blue Green Yellow

what i want is a cell that looks like this

B1 Blue
Green
Yellow

when i am typing a paragph i can use Alt/Enter to create the paragraph but not sure if or how to put a parapgrah break after a cell reference while concatenating.

any ideas?

Try the CHAR(10) for the Alt+Enter.

=A1&CHAR(10)&A2&CHAR(10)&A3

then Wrap Text to show.
HTH, Ed

 

[michaelsmithgall]

Thank you so much both of you. That worked perfectly

 

[TJwAsadIQ]

Try the CHAR(10) for the Alt+Enter.

=A1&CHAR(10)&A2&CHAR(10)&A3

then Wrap Text to show.
HTH, Ed

I am running excel 2011 on a Macbook Pro 10.9.5. For me, CHAR(10) does not work, but CHAR(13) does.

=A1&CHAR(13)&A2&CHAR(13)&A3

gives the desired results.