Insert paragraph using formula

[ajith]

Hello,
Is there any method to start a new paragraph for a long text which uses "Concatenate" within a cell.

eg. =Concatenate("aaaaaaaaaaaaaaaaaaaaaaaaaaa ","bbbbbbbbbbbbbbbbbbbbbbbbbbb")

I would like to get the 2nd text ie "bbbbb..." as the next paragraph within the same cell. So finally it should be
aaaaaaaaaaaaaaaaaaaaaaaaaaa
bbbbbbbbbbbbbbbbbbbbbbbbbbb

 

[FDibbins]

maybe this?
="aaa"&CHAR(10)&"bbb"
you will need to set "Wrap Text" and adjust column widths

 

[ajith]

Thank you very much.

where can i get the full list of excel CHAR( )

 

[mikerickson]

I put =ROWS($1:32) in cell A1 and =CHAR(A1) in cell B1 and drag down. It makes its own chart.

For 10 thru 31, you might want the secondary formula to be ="x"&CHAR(A1)&"x"

 

[FDibbins]

A quick search for ASCII tables will show you them, here is 1 such link
http://www.asciitable.com/