=A2&B2&"."&C2
or without the need for col A
$3.47

=DOLLAR(B2&"."&C2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Alain Dekker" wrote in message
...
Hi,

Using Excel 97.

I'm trying to generate a list of costs of some stock items:
So I have columns:
Dollar_Symbol
Dollar_Amount
Dollar_Cents

eg.
Column A Column B Column C
Dollar_Symbol Dollar_Amount Dollar_Cents
$ 3 47
$ 12 09

etc

Now I want to concatenate these into a string ie. something like this:
A2+B2+"."+C2 (which should $3.47)
A3+B3+"."+C3 (which should $12.09)
but I can't get the formulas to work. I'm sure this is simple, I'll kick
myself later, I promise!

Thanks in advance,
Alain