="500" & CHAR(10) & A1+B1 entered in C1

Set C1 to wrap text.


Gord Dibben MS Excel MVP


On Fri, 26 Sep 2008 10:47:01 -0700, Té wrote:

I have a number in a1 which is 500. Is there a way I can leave the 500 in
place, along with add a formula to that cell as well. I want to add a1+b1,
but I want to keep the 500 there. I know alt + enter goes down to the next
line, but when I insert the formula it doesnt work.