How do I get a line break when using a formula to combine cells
Be sure to format to allow line-wraping, then use:
=A1 & CHAR(10) & B1
in place of
=A1 & B1
--
Gary''s Student
"TESA0_4" wrote:
I want to combine names and addresses into single cells, but I want a line
break so that the name is on one line and the address on the next line within
a cell. When manually entering data to a cell ALT,ENTER gives line break. I
want the formula to give the same effect as ALT,ENTER.
I'm using Excel2003.
Thanks if you can help!!
|