Concatenate

[Drreamsurferr]

Hi

I have a file that is formatted in text as follows:

2009113000000000000080928102EUR

Seperated out it looks as:

20091130 80928102 EUR

I need to add the zeros back to the 2nd column (80928102) in excel & save merge the columns back to look the same as the original txt format so I can save the txt file - how can I do this? what formats/concatinations need to be applied???

Thanks!!! :-)

[Ron Coderre]

With A1:C1 containing these values

20091130   80928102   EUR

This formula rebuilds the text string you are looking for:

D1: =A1&REPT("0",31-SUMPRODUCT(LEN(A1:C1)))&B1&C1

In the above example, the formula returns:

2009113000000000000080928102EUR

Is that something you can work with?