Handling imported dates, some with a trailing space

[JonnieB]

An external query of a web database returns names and dates, Col A & Col B on the attached work book. Some, but not all, of the dates have a trailing space. I want to convert the dates (which are in US format mm/dd/yyyy) to their Excel date-time code so that I can perform subsequent operations and format UK dd/mm/yyyy.
I've browsed several possible solutions e.g. (TRIM) and Find/Replace which appear to remove the space(s) but the date then stubbornly refuses to convert to Excel date-time code. I've also tried the Web query with the option "Match Destination Formatting" (general) without success.

Is there a solution which doesn't involve VBA?