You are spelling it wrong (you have an extra c). Are you spelling it like
that in excel? I never use that function.

=CONCATENATE(A1,B1,C1)
and
=CONCATENATE(A1,TEXT(B1,"00"),C1)
both work for me.

"killertofu" wrote:


Thanks a bunch for the help.

How come CONCACTENATE wouldnt work for this?


--
killertofu
------------------------------------------------------------------------
killertofu's Profile: http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=512406