Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Concatenate Function ... Help .... Please!!

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

    Default

    Dreamboat,

    I will try your suggestion. I agree that it is easier to read and it may have more functionality.

    Thank you for the tip!

  2. #12
    Board Regular
    Join Date
    Mar 2002
    Location
    Leiden, The Netherlands
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK, so this is what the formula should look like:

    =CONCATENATE("Any Company, USA Operations reported a combinded net ",H26, " of ", TEXT(G26,"""USD"" ###.###.##0.00;(""USD"" ###.###.##0.00)")," compared to a budgeted net ",I26," of ",TEXT(F26,"""USD"" ###.###,##0.00;(""USD"" ###.###,##0.00)")," for the month of ",B15)

    Note the double-double quotes around USD. In general, if double quotes occur in the original format, you should double them in the formula.

    I hope I didn't make any mistakes copying the formula from my Excel sheet: I'm working with a Dutch version with commas as decimal separators and semicolons as argument separators. So perhaps you'll have to make some minor ajustments.

    Have a good day!
    Marc



    [/quote]

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
  •