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!!! :-)