Custom Formatting of nos. separated by hyphen

Hi!

I wish to join no. content of 2 cells and then separate the result by hyphen.
The length of characters in the original cells can vary but the custom formatting result should remain the same as below:

A1: 12345
B1: 123456
C1: 12,345-1,23,456 (Expected result)

No. length of original cells can vary but display format result has to be in following fashion: XX,XX,XX,XXX-XX,XX,XXX (i.e. last three digits after comma and all preceeding digits in groups of two)

Example:
1. 123-12,345
2. 1,234-235
3. 12,345-1,345
4. 1,23,456-23,345
5. 12,34,567-1,23,456
6. 1,23,45,678-12,345
7. 12,34,56,789-1,23,456

Any ideas on a formula or custom formatting to get this result?

Thanks

Originally Posted by vlady

try
=CONCATENATE(TEXT(A1,"#,###"),"-",TEXT(B1,"#,###"))

Thanks vlady
Your solution works as required.

Hi there, I am trying to do the oppsite of concatenate; I have the string shown below and need to separate th 4 digit number onloy in the next column. Is there a function for that ?

T-2331[b]-NELINDA-T.10

Thanks Vlady, I just did.

Cheers !