Thread: How do I combine text and formula within the same cell?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Office Office is offline
external usenet poster
  
Posts: 2
Default How do I combine text and formula within the same cell?
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 :)
Reply With QuoteReply With Quote