Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: excel

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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



  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,042
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    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

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    115
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •