=A1&" "&TEXT(B1,"0000")&" "&C1

Vaya con Dios,
Chuck, CABGx3


"mac52187" wrote in message
...
Thanks for the reply Paul. But the problem is
I used CONCATENATE(A1," ",B1,"; ",C1) Where B1 is formatted as"000000"
the problem is that the result is ABCD 123; XYZ Where as is need it to be
ABCD 000123; XYZ.( here 123 can be any 6 digit number with preceeding
zeroes)