Text plus formula
 

Is there a way to have a formula and some text after the formula in the same
cell?

Text plus formula
 

If you mean text that shows in the cell then something like:

=SUM(A1:A20)&" Total of Column"

if you mean text that will not show in the cell then something like:

=Sum(A1:A20)+N("This is an explantion of what the formula does")


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Beep Beep" wrote in message
...
Is there a way to have a formula and some text after the formula in the
same
cell?

Text plus formula
 

Like this

=A1+A2 & " My formula adds up A1 and a2"

Mike

"Beep Beep" wrote:

Is there a way to have a formula and some text after the formula in the same
cell?