Text to columns not separating date and time

[bchez]

01/18/2019 5:30 AM

<tbody>
</tbody>

I need to separate the date from the time using text to columns. Here's the original above in the leftmost column. The data is in Custom number format mm\dd\yyyy h\mm AM/PM
When I use text to columns delimited here is how it splits out (I will just show you the first row)
01/18/2019 12:00 AM in column A
01/00/1900 5:30 AM in column B
As you can see it keeps the date and time together but changes the time to 12:00 AM in column A and puts yet again another date and time in column B as 01/00/1900 5:30 AM
The net result is the correct date in col A and the correct time in col B but it won't split the date from the time. I need the date in one column and the time in another column.
Any ideas without using VBA? Thank you

 

[sandy666]

after text2columns format col A as short date and col B as time (or Custom Format: h:mm AM/PM)

 

[bchez]

after text2columns format col A as short date and col B as time (or Custom Format: h:mm AM/PM)

That worked very nicely sandy666 thank you very much.

 

[sandy666]

you are welcome & have a nice day