Hi All,

I wonder if I could get someone could point me in the right direction:

I am trying to find an easy way to change the format of forex price data from:

21 06 2018 23:00:00 94.878 94.884 94.845 94.866

to
2018.06.13 10:00 93.884 93.976 93.865 93.921 18501

The challenge is that the 1st column in bold has both date and time in 1 column and the date format is not with the dot and not recognized by excel. Can this only be done manually or can this be done by an formula / Macro?

Thanks you to anyone who could advise.

regards,
Ivo