Archive of Mr Excel Message Board

Back to Controls in Excel archive index
Back to archive home

New Line in a formula

Posted by shoopes on January 09, 2002 9:35 AM
I'm trying to fetch data from multiple cells, and put it all in one cell. I use the following to get the label and data, but I need to put a hard return to move to the next line for the next label/data pair:

=a1&": "&a2 {hard return}
&b1&": "&b2 {hard return}
Where a1 and b1 are labels, and a2 and b2 are data.

Re: New Line in a formula

Posted by Juan Pablo G. on January 09, 2002 9:46 AM
Replace {hard return} with CHAR(10)

Juan Pablo G.

This archive is from the original message board at
All contents © 1998-2004
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.