Hi AlphaFrog
Did you test this and did it work for you. If so I am unlucky as I tried it no luck no Luck. In my original file i also had some Jul and Jun dates which converted themselves to dates perfectly.
'Cells.Replace What:="*/", Replacement:="/", LookAt:=xlPart, SearchOrder _
' :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
Columns("A").Replace What:="/", Replacement:=" ", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
Mark
The ' to mark as commented out is not very clear - Basically the first two lines.
Bookmarks