=A1 & CHAR(10) & B2

or

format - cells - alignment - wrap text

?

tim


"marwan hefnawy" wrote in message
...
How can I split the text in any cell in two lines, given that the text is
a
result of some equation of cancatination (text1 & text2 & text3...)
I tried the (ALT+Enter) keys as used with the ordinary text, but it didn't
work. (Only the formula in the formula bar is splitted not the resultant
text in the cell)