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
Bookmarks