Thread: Mixing text and formulas in the same cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Markus Fritsche Markus Fritsche is offline
external usenet poster
  
Posts: 1
Default Mixing text and formulas in the same cell
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
Reply With QuoteReply With Quote