View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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