excel

[Sylvain Desjardins]

Hello out there

I have tow cells side by side one cell has ( Total Hours ) and the other cell has (=somme(D13:D16) ) giving me the result of the hours calculated in those cells. I want to had text to that result ex: ( Technicians 40 ) how can i insert text in that equation. I just want the text to appear with the total.

Thank you in advance,

Sylvain Desjardins
technical director
Théâtre du Casino

 

[Aladin Akyurek]

On 2002-04-25 13:29, Sylvain Desjardins wrote:
Hello out there

I have tow cells side by side one cell has ( Total Hours ) and the other cell has (=somme(D13:D16) ) giving me the result of the hours calculated in those cells. I want to had text to that result ex: ( Technicians 40 ) how can i insert text in that equation. I just want the text to appear with the total.

Thank you in advance,

Sylvain Desjardins
technical director
Théâtre du Casino

=somme(D13:D16)&" Technician 40"

Aladin

 

[bergy]

Try this:

=CONCATENATE("Tech ",SOMME(D5:D8))

Make sure you have a blank space after the job title and before the last quotes, or else the job title will run into the hours