Run an Edit -> Replace on Column A replacing AM with _AM where _ is a space.
Repeat for PM.
Alternatively - if you wish you could combine A & B into a single DateTime stamp in a new Column via formulae:
![]()
C2: =B2+REPLACE(A2,FIND("M",A2)-1,0," ") copied down
Bookmarks