Strange Date Format 11/4/14, 1:09 PM will not convert to Excel Date Time due to comma placement

[Rx_]

A popular product has an Export to Excel with a single column for Date / Time.
The format shown has the date [comma] Time.
It won't convert to a Date date type due to the comma.

A popular software tool takes this data off of the internet and converts it to this text string.

I can manually use the Text to Columns to split this using the comma as the delimiter.
I am able to write a macro to remove the comma among other options.

I have failed to find a "custom" format that could convert this format to a Date Time.
The problem is: I want to enable people who don't have much Excel Skills to download and convert this column to a Date/Time field.

What would be the most simple way to remove the comma from this Date, Time string?


[TABLE="width: 123"]
<tbody>[TR]
[TD]

[TABLE="width: 123"]
<tbody>[TR]
[TD]Date / Time[/TD]
[/TR]
[TR]
[TD]11/4/14, 1:09 PM[/TD]
[/TR]
[TR]
[TD]11/4/14, 1:26 PM[/TD]
[/TR]
[TR]
[TD]11/4/14, 1:26 PM[/TD]
[/TR]
[TR]
[TD]11/4/15, 1:28 PM[/TD]
[/TR]
[TR]
[TD]11/4/16, 1:28 PM[/TD]
[/TR]
[TR]
[TD]11/4/17, 1:44 PM[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
</tbody>[/TABLE]

This worked - Select Column - used Find And Replace - for Find enter a comma, for replace put in one space.
It replaced all of the columns. And now they become Time Date data types.

if anyone else has a better suggestion, please let me know.

 

[MARK858]

Select the column then use find-replace. Put , in the find box and leave the replace box blank (obviously match entire cell contents needs to be unchecked).