Combining mulitple cells contents without losing the leading zeros

[mlu120]

Good morning,

Is there a macro that I can use to combine multiple cell contents into one cell and this one cell must have a total of 190 character spacing. At the same time some of the contents of a cell require specific spacing and can not lose the leading zeros.

Here is the excel formula =CONCATENATE(TEXT(C1,"000000000#"),TEXT(D1,"00000000.00#"),TEXT(E1,"00000#"))

Finally, I have to convert and save the file as a text document to be uploaded.

I would appreciate the help. Thank you AMY