Excel - Text plus formula

Asked By BeepBee on 17-Apr-08 03:56 PM
Is there a way to have a formula and some text after the formula in the same

Sandy Mann replied on 17-Apr-08 04:05 PM
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")


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

Replace @mailinator.com with @tiscali.co.uk
Mike replied on 17-Apr-08 04:06 PM
Like this

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