Help with Excel query

Hey Guys,

Can anyone help me with this Excel query or point me in the right direction?

I am fairly new to Excel but I've been trying to edit this data from the forex tester database. It is in .CSV so I import it into Excel but I'd like to change the date and time columns so they are a little more usable. This is how it appears after import:

XAGUSD200101022309004.574.574.574.574

But I'd like to have it like this:

XAGUSD2001:01:0223:09:004.574.574.574.574

I have tried just editing one cell and dragging down but I don't think it likes duplicates so it seems to automatically change the dates to go in series and as this is is M1 data there are a lot of date duplicates.

Any help would be much appreciated.

James.

I would import the data first into a dataminer like Knime. Not sure but you should be able to do the customization in there.

Will give it a try cheers.

Try this formula
=MID(A1,1,10)&":"&MID(A1,11,2)&":"&MID(A1,13,4)&":"&MID(A1,17,2)&":"&RIGHT(A1,19)