Split date into different format

[danielpeam]

Hey guys,

I have a problem splitting a date format into different columns.

The dates appear like so - Tuesday, March 6, 2018 3:23:52 PM GMT within the cell would like this split by D/M/Y - any ideas?

 

[arthurbr]

Are those dates text or real dates formatted to look like this ( if the string is right aligned when no manual alignment is applied it's the latter)

 

[Special-K99]

=(text("01/"&trim(mid(substitute(substitute(a1, " ", rept(" ",50)),",",""),50,50)),"m")&"/"&trim(mid(substitute(substitute(a1, " ", rept(" ",50)),",",""),100,50))&"/"&trim(mid(substitute(substitute(a1, " ", rept(" ",50)),",",""),150,50)))+0