Mixing text and formulas in the same cell
A couple mo
=A1&": "&text(sum(a1:c2),"$#,##0.00")
or
="Client Name: "&text(sum(a1:c2),"$#,##0.00")
johnu wrote:
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
--
Dave Peterson
|