Cell data and text in the same cell

[Svefnleysi]

This has probably been asked before, but I couldn't find the answer, so here goes:

Is it possible to show the data from a certain cell and then add text to that in the same cell.

Let's say I want to show the data from C13 and then continue on in that same cell with some text. Let's say 'blahblah'. How can I do that?

[mubashir aziz]

Lets say you are in Cell A5 and you want to write sum of A1:A4 and write in Cell A4 Sum is "Total" ...

Just write below formula in

A1 = 1
A2 = 2
A3 = 5
A4 = 4



A5 = ="Sum is "&SUM(A1:A4)

Result Sum is 12

[Svefnleysi]

Ah. Thanks, man.

[nawas]

thanks mubashir....