View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
0-0 Wai Wai ^-^
 
Posts: n/a
Default 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. :-)
..
..
..