That doesn't seem to work with UK regional settings, Cutter - I suggest this formula
=REPLACE(MID(A2,9,11),3,0,"-"&MID(A2,5,3)&"-"&RIGHT(A2,4)&" ")+0
that works with UK or US regional settings and should also work with 02 Nov or 2 Nov
format result cell any way you want, in your case dd/mm/yyyy hh:mm
Bookmarks