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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Wrkn4alivn" wrote in message
ups.com...
I have tried everything to convert 5 columns into a single string. The
problem is that these cells contain preceeding zeros, and when I try to
convert them into a string using "&" or "concatenate" the preceeding
zeros are deleted.

Ex. Col. 1 Col.2 Col.3 concatenate or string
I get
000321 032140 001547 321321401547



Please help.