Clara, to get two lines in one cell use Alt+enter, is that what you need?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"clara" wrote in message
...
Hi all,
I put the Cell1Add & char(10) & Cell2Add into another cell and the
content
from Cell1 and Cell2 are put in seperate lines. The question is the
containing cell did not collapse automatically to display the multiple
lines.

Clara


thank you so much for your help