Writing Text and Formula in the formula bar of a cell

Hi,

I have a cell say N1, in which I am supposed to write something which will look like this:

Please Login or Register  to view this content.

Now the number 5421 is generally a sum of series of cell, for example:

Please Login or Register  to view this content.

For now I calculate the sum in a temp. cell and then manually write the sum (5421) in the N1 cell's formula bar.

Now how can I do the same without using the temp cell i.e. can I use a Text and a Formula together in the same cell?

Thanks

Originally Posted by oldchippy

Does this work for you?

="Mean (N="&SUM(B4:J4)&")"

Yes that worked.......Thanks a lot...