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 !!