Is there a way to strip text from a date. I know how to use the LEFT and RIGHT functions to remove characters from strings but what about for dates. When I use the LEFT function on the date below to remove the "a",
1/13/15 15:04 a
it becomes a text format that won't change back to date format. When I manually delete the "a", it works fine and stays as a date but I have thousands of these and can't manually do it. Is there a way to strip those "a"s?