MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

Posted by Juan Pablo G. on January 09, 2002 9:46 AM

Replace {hard return} with CHAR(10)

Juan Pablo G.