In C1 enter:
="Total = " & 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