How do I get a line break when using a formula to combine cell
Great! Thanks for the help.
However, can you help with a follow-on question? Where do I go to review
what each CHAR value is and the functional effect that it has in a formula.
In other words, how can I work out that CHAR(10) has the same effect as
ALT,ENTER in a cell?
"Gary''s Student" wrote:
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!!
|