Hi,

I once knew how to add text to a formula, which I'd use to explain the
formula rather than using cell comments.

I can't for the life of me remember how to do this.

Any help would be greatly appreciated.


James

Hi James

Try
=Sum(A1:A100)+N("This adds the total Gross Amount")

Change to suit.

Regards

Roger Govier


James Hamilton wrote:
Hi,

I once knew how to add text to a formula, which I'd use to explain the
formula rather than using cell comments.

I can't for the life of me remember how to do this.

Any help would be greatly appreciated.


James

James, use something like this, ="This is the sum of A1 + B1 " & A1+B1

--
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

"James Hamilton" wrote in message
...
Hi,

I once knew how to add text to a formula, which I'd use to explain the
formula rather than using cell comments.

I can't for the life of me remember how to do this.

Any help would be greatly appreciated.


James

Thanks Roger and Paul - the +N("blah, blah") was how I used to do it.


James

"James Hamilton" wrote:

Hi,

I once knew how to add text to a formula, which I'd use to explain the
formula rather than using cell comments.

I can't for the life of me remember how to do this.

Any help would be greatly appreciated.


James