concatenate two cells, but with conditions

[Programmer wanna be]

I need to concatenate two cells, the cells have to be formatted to text.

Column A is CREDIT LIMIT
Column B is 10000

The end result should look like this: CREDIT LIMIT $ 10,000

Remember, the cell has to be in text format.

Please, someone help, my head hurts !!

 

[LarryP]

CellA & " $" & CellB. Using the & operator automatically
produces a string (text) result

 

[Frank Kabel]

Hi
try
=A1 & " " & TEXT(B1,"$ 0,0")