Split timestamp column into separate date and time columns in excel

Question

I have a dataframe with a thousand timestamps like the following one:

05.03.2018 08:18:37.827

I am having difficulties splitting this timestamp into two columns: Date and Time. I am not able to use the formula =INT(A2) and then =A2-B2 because the date is like this 05.03.2018. It should have been this 05/03/2018.

However, it is impossible for me to change the . to / for all the cells. It will take days to do it. If someone can help me with this?

Answer 1

Kutools for Excel allows you to split date and time (3 steps with clicks)
Select the date and time cells, then go to Kutools > Merge & Split > Split Cells to merge and split them.
Check the Split to Columns and Space options in the Split Cells dialogue. Take a look at this example:
Select a cell to output the separated values and then click OK.