How do I calculate a sum in a cell as well as showing text in the same cell? [closed]
Just as the title suggests. For example I want cell C1 to display the total of cells A1 ad B1, (=A1+B1) as well as some text unrelated to the calculation as well. How would the formula look?
Each time I enter text anywhere in the cell (C1) it just screws up the calculation. I have tried putting it before and after the calculation, have tried using quotation marks too.
Can this be done, and if so, how?