Hi,

Pls copy the data and paste (crtl +v) and use text to column (alt d +e ) and go to delimited > and choose space > next > select datetime column> change column format as date > finish....