Parse a date+time field into separate date and time cells

Hi team,

Thank you for your help in the past. I would really appreciate some insight here as I have been exporting from a system which provides date and time like this, all in one cell:

Please Login or Register  to view this content.

My end result would be

Unstructured Date
6/10/2019 9:21

-->>>

Date
6/10/2019

Time
9:21

As you can see, a simple =Mid or =Find function may not work, because the Month could be 6 or 10, for June or October, and the time could be 17:00 or 9:00.

Please advise! (attached a csv as well)

Thank you again,
Meow

I know its a manual way, but can you find and replace your space between your time and date and replace it with say, 4 spaces, then do a data split?

so you find (without quotations) " " and replace with "5 spaces" (no quotations again and it was only showing one in my post, but 5 spaces not the words) this should space things out for you, then...

Data tab - Text to Column - Split fixed width spaces - insert a break after your date length (2-3 spaces in should do the trick this way your date and time are not affected by the split)

And insert in to new column.

Didn't see alan's post that may be a better way to go about it...

Thanks all.