How to put text and function() in one cell

[deepak_message]

Hi All,

I am able to use function() and use text in one cell but not the text and function.
such as , deepak =sum(A1:A2) in one cell.

Thanks in advance for the helping.

 

[AD_Taylor]

Use:

= "deepak" & SUM(A1:A2)

The = always comes at the start and any text should be enclosed with quotations.

 

[BeingYogi]

May be


=CONCATENATE("Deepak=",SUM(A2:A3))