Thread: use concatenate function to put carrage returns in a text string
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default use concatenate function to put carrage returns in a text string
Hi!

Try this:

To concatenate A1 and B1 with a "hard return" in-between:

=A1&CHAR(10)&B1

Format the cell to wrap text:

FormatCellsAlignmentWrap text

Biff

"dabblingandconfused" wrote
in message ...
How do I use concatenate to assemble a string that includes carrage
returns?


Reply With QuoteReply With Quote