Revision history [back]

You may enter formula like this:

="This is sum: " & A1+B1 & " dollars"


Or you may use cell's (style's) number format to add text beside number, like this:

"Sum: " # ##0,00 " cups"


The latter allows you to continue using the cell in further calculations (it only affects appearance; the inner cell contents is still the number).