Results 1 to 3 of 3

Concatenate with multiple alignment

Threaded View

tigabalm Concatenate with multiple... 04-04-2011, 08:49 PM
davesexcel Re: Concatenate with multiple... 04-04-2011, 09:47 PM
tigabalm Re: Concatenate with multiple... 04-04-2011, 09:53 PM
  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.

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