String

[Dave]

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

 

[Jim May]

In C1 enter:
="Total = " & A1+B1

 

[Zone]

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

 

[David Biddulph]

But if you want C1 still to be a number (rather than a text field) for
further calculations, use C1 =A1+B1 and custom format as
"Total="0

 

[Dave]

When you say custom format "Total="0, is this an option in excel the
custom format.

 

[David Biddulph]

Format/ Cells/ Number tab/ Custom, & put that format in the "Type" field.

 

[Dave]

Ok Many thanks David.

Format/ Cells/ Number tab/ Custom, & put that format in the "Type" field.