Insert manual line break in formula
"Ron Coderre" ¦b¶l¥ó
¤¤¼¶¼g...
Try something like this:
="I am a "&A30&". You are a "&A31&". "&CHAR(10)&"However we don't "&A32&",
nor "&A33&". "&CHAR(10)&"Except that, we do "&A34&"."
Note: You'll need to set your cells to wrap text and set column widths.
FormatCellsAlignement Tab
Check: Wrap Text
Does that help?
It helps a lot although this solution is not perfect. :D
By the way, would you mind telling me what's the point of adding "CHAR(10)"?
I would like to understand why.
Thanks. :-)
..
..
..
|