Mixing text and formulas in the same cell

[johnu]

I would like to mix a formula with text in the same cell, something like
“Client Name & sum(A1:C2)â€
Any help would be greatly appreciated.

Thanks,

John

 

[Jim Thomlinson]

Where is the cliend name stored. Assuming it is in A10 you could do soemthing
like this...

=A10 & " " & sum(A1:C3)
or
="John Smith " & Sum(A1:C3)

Note that when you add the text the cell is no longer numeric so you cna not
do any further calculations against it...

 

[Markus Fritsche]

Am Tue, 16 Sep 2008 12:58:15 -0700 schrieb johnu:

I would like to mix a formula with text in the same cell, something like
´Client Name & sum(A1:C2)¡
Any help would be greatly appreciated.

="Client Name " & sum(a1:c2) & " suffix"

Kind regards,
Markus

 

[Dave Peterson]

A couple more:

=A1&": "&text(sum(a1:c2),"$#,##0.00")
or
="Client Name: "&text(sum(a1:c2),"$#,##0.00")