help me convert a weird text string to a date

[alyarb]

This is the date format our backup server uses

2013/01/10 11:00PM


genius, i know.

anyway, i would like to first do a find and replace to get rid of the xx:xxPM or AM and get rid of the time. and from there, i know there will be some function like

=DATE(LEFT(H2,4),MID(H2,5,2),LEFT(H2,2))

but everything i've tried hasn't worked. i'm terrible with excel! what do you guys think?

thanks!

 

[Ken g6]

Assuming the format is static:

=DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))

Stupid Excel starts counting letter positions from 1, not 0.