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.