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?

Many thanks!