Thread: String
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Zone Zone is offline
external usenet poster
 
Posts: 269
Default String

Put this formula into C1:
="Total="&SUM(A1:B1)

Dave wrote:
Is there way with a calculation to display the text in the same cell.

Say:

a1=1 b1=2 c1=3(Total)

In c1 say, could you get the cell to display: Total=3