Mixing Formulae and Text in one cell

  • Thread starter Thread starter :-)
  • Start date Start date
?

:-)

Can I write a sentence in an Excel cell which contains both text and a
formula eg "The total therefore is SUM(A1:A5)"
 
Or you can leave the cell containing only the formula =SUM(A1:A5) and put
the text in the cell's formatting. Select custom format and enter "The total
is therefore" general, where general can be replaced with any of the
formatting options like 0 or 0.00, etc. The advantage of this method is that
the cell is still a numeric value instead of a text value and can be used in
subsequent calculations.

Bill
 

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

Excel formula, sum the value cell and if empty cell left blank 0
Excel ignore formula 8
How to set cell value to emptry if three other columns are empty too 1
Excel text formula trouble 1
Mutiply in a range of cells ? 1
SUM / COUNT formula 3
dynamic vlookup then sum 3
Formula Query 9

Back
Top