CellA & " $" & CellB. Using the & operator automatically
produces a string (text) result
-----Original Message-----
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 !!
.