Concatenate $ amounts

[sobrien1234]

I want to concatenate 2 $ amounts but I lose the $ and the , in between the numbers. For example:
A1 = $100,000
B1 = $200,000
C1 = concatenate (a1," & ",B1)

The result I get is
100000 & 200000

So I lose the $ and the commas. Any suggestions?

thanks

 

[tyija1995]

Hey, try this:

=CONCATENATE(TEXT(A1,"$#,##0;-$#,##0")," & ",TEXT(B1,"$#,##0;-$#,##0"))

 

[Gerald Higgins]

You haven't said what you would like the result to be, I assume you want

$100,000 & $200,000

which you can get with something like this

=TEXT(A1,"$#,##0")&" & "&TEXT(B1,"$#,##0")

 

[sobrien1234]

Brilliant!! Thank yuo!!!