Enter Text and Formula in same cell

Sherrell · Dec 8, 2003

Is it possible to enter text "Total is" and also enter the formula to
total the column in the same cell? If so, how?

Paul · Dec 8, 2003

Sherrell said:
Is it possible to enter text "Total is" and also enter the formula to
total the column in the same cell? If so, how?

Something such as:
="Total is "&SUM(A1:A10)

Andy B · Dec 8, 2003

Sherrell

Try this:

="Total is £"&SUM(D11

14)

Andy.

Jim Rech · Dec 8, 2003

The way I do things like that is with a custom number format. Format,
Cells, Number, Custom and paste this in:

"Total is: "#,##0