Thank for your help.

Unfortunately the credit limit values change depending on account the
formula is assigned to. Is there a way to automatically, through a
formula determine the amount of characters, then assign the commas
accordingly?

thanks

"Frank Kabel" wrote in message ...
Hi
try
=A1 & " " & TEXT(A2,"$ 0,0")

--
Regards
Frank Kabel
Frankfurt, Germany


Programmer wanna be wrote:
I have two cells I need to merge: The first:

CELL A1: CREDIT LIMIT
CELL A2: 10000000

The end result needs to look like this:

CREDIT LIMIT $ 10,000,000

Please help.