+ Reply to Thread
Results 1 to 3 of 3

Concatenate with multiple alignment

  1. #1
    Registered User
    Join Date
    07-01-2009
    Location
    Seoul, South Korea
    MS-Off Ver
    Excel 2003
    Posts
    21

    Concatenate with multiple alignment

    Tried searching, and found something similar, but didn't seem to be working for my case. So now I come back to ask the help of the excel masters

    Basically I'm trying to format a financial statement with multiple currencies.

    In my spreadsheet I have:

    123456789 | 123456
    987654321 | 987654


    and so on for hundreds of account titles. So far my formula looks like this:
    =CONCATENATE("KRW: "&TEXT(A1,"#,###"),CHAR(10),"USD: "&TEXT(B1,"#,###"))
    which outputs:

    KRW: 123,456,789
    USD: 123,456

    What I am looking to do is have it where the numbers are aligned to the right and the text is aligned to the left.

    Sorry for the long winded explanation, but I'd really appreciate any help you guys could provide.

    Thanks

    EDIT: Okay, not familiar enough with html formatting, so the spacing isn't displaying properly, so I've attached the file to better explain whats happening
    Attached Files Attached Files
    Last edited by tigabalm; 04-04-2011 at 08:53 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Concatenate with multiple alignment

    Hello,
    Why would you not use different cells?

  3. #3
    Registered User
    Join Date
    07-01-2009
    Location
    Seoul, South Korea
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Concatenate with multiple alignment

    Hi,

    I was thinking of that too, but the format is kinda sensitive and adding cells would require a rework of the entire form so I was hoping to do that as a last resort...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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