Text in a Formula

[James Hamilton]

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

[Roger Govier]

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

[Paul B]

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" <[email protected]> wrote in message
news:[email protected]...
> 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 Hamilton]

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