+ Reply to Thread
Results 1 to 4 of 4

Concat help

  1. #1
    Registered User
    Join Date
    03-14-2013
    Location
    noida
    MS-Off Ver
    Excel 2007
    Posts
    5

    Concat help

    Dear All,

    I am using the formule to concat 2 cells with the 2 nd to be in braces

    =CONCATENATE(C29," (", C39, " )")

    My first cells(c29) contains revenue in Gbp and after concat it is not showing the Symbol($).
    My C29 has revenue in decimal system. But after concat the 2 decimals are not seen.Few come with no decimas, few with 1 decimal and others with 2 decimals ...please help me to get all with out having decimals.

    ex: After Concat:

    0 (0 ) 0 (0 ) 0 (0 ) 248 (1 )
    14720 (55 ) 715.1 (60 ) 24264.1 (87 ) 54309 (244 )
    49505.25 (216 ) 73349.44 (337 ) 112547.74 (364 ) 154332.42 (511 )

    Please help to get all data to be in 0 decimas.

    Thanks

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Concat help

    how about with text function

    =CONCATENATE(TEXT(round(C29,0),"$0.00"),"(", TEXT(round(C39,0),"$0.00"),")")
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    03-14-2013
    Location
    noida
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Concat help

    Such a quick and Ameazing Solution Thanks VLADY

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Concat help

    Your very much welcome and thank you for joining the forum.

    Regards,
    Vlady

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1