Assuming every cell has the same format, I would use MID to extract the year, month, day, hours and minutes and DATE + TIME to get the date/time in a cell and then format it as required.

Regards, TMS