Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine text into a cell??? | Excel Worksheet Functions | |||
Combine text and formula? | Excel Worksheet Functions | |||
How to combine 2 cells' text into 1 cell | Excel Discussion (Misc queries) | |||
Combine Formula and static Text | Excel Discussion (Misc queries) | |||
Formula to combine text? | Excel Worksheet Functions |