How do I combine dollars and text

[Kesbutler]

I want to combine two different cells that contain dollars and text. when I
try it always drops the $ sign. How do I do this? Example cell A2=$40 and
cell A3 is per year, I want in one cell $40 per year.

 

[Mike H]

I suspect the $ sign in a2 is a format so try this

=TEXT(A2,"$"&0)&" "&A3

Mike

 

[Gary''s Student]

="$" & A2 & " " & A3

 

[Kesbutler]

these both get me the $ but now they drop the comma's for larger numbers like
$4,000,000 and I am working with millions so I need it.

 

[Gary''s Student]

=TEXT(A2,"$#,##0") & " " & A3

This formula makes no cents.

 

[Gord Dibben]

=TEXT(A2,"$#,##0.00") & " " & A3


Gord Dibben MS Excel MVP