Extract Date and time from the Text Column

[Rick Rothstein]

Give this formula a try (Custom Format the cell to display the date-time format you want)...

=0+SUBSTITUTE(TRIM(LEFT(RIGHT(SUBSTITUTE(A1," ",REPT(" ",300)),1500),1500)),",","",2)

[zorro]

Thanks, not sure if it is running or not, gives #VALUE!