concatenate two cells, but with conditions
 

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

concatenate two cells, but with conditions
 

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

concatenate two cells, but with conditions
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Programmer wanna be wrote:
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 !!