How do I combine text and formula within the same cell?

  • Thread starter Thread starter Office
  • Start date Start date
O

Office

if I wanted to have the word TOTAL or any other general text (eg Total cost
of project) then a formula that sums a number of values
total =SUM(A2:A10) in the SAME cell Everything I have tried to do this
either end up with the text staying and the formula doesn't calculate....or
the text is removed and the formula calculates
Your help would be greatly appreciated :)
 
Another way to give the amount a nice format:
="Total cost of project: " & text(sum(a2:a10),"$#,##0.00")

But you could keep the value in the cell a number and use a custom format:
Put
=sum(a2:a10)
in the cell
Format|Cells|Number tab|custom|
"Total cost of project: " $#,##0.00
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Text From Cells 3
sumifs problem 1
how do i copy the actual text of a formula? 7
Problem using formula after formatting cells 2
Divide within the same cell 2
Mixing text and formulas in the same cell 3
Passing text into a formula? 8
Adding numbers and text 6

Back
Top