|01/18/2019 5:30 AM|
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