Split timestamp column into separate date and time columns in excel

0 votes
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?
Apr 11 in Database by Edureka
• 13,640 points
890 views

1 answer to this question.

0 votes

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.

How to split date and time from a cell to two separated cells in Excel?

How to split date and time from a cell to two separated cells in Excel?

answered Apr 11 by gaurav
• 22,040 points

Related Questions In Database

0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24 in Database by Edureka
• 13,640 points
784 views
0 votes
1 answer

How do I split a cell in Excel into two or more where they are divided horizontally?

Table cells should be combined. To make a ...READ MORE

answered Apr 6 in Database by gaurav
• 22,040 points
376 views
0 votes
0 answers

How to convert date into timestamp in SQL query?

I'm attempting to move data from the ...READ MORE

Aug 19 in Database by Kithuzzz
• 20,660 points
202 views
0 votes
0 answers

How to concat two columns into one with the existing column name in mysql?

Using MySQL, I want to combine two ...READ MORE

Sep 6 in Database by Kithuzzz
• 20,660 points
37 views
0 votes
1 answer

Difference between datetime and timestamp in sqlserver?

Timestamp is a synonym for rowversion, according ...READ MORE

answered Feb 16 in Database by Vaani
• 7,020 points
1,706 views
0 votes
1 answer
0 votes
1 answer

Date difference: different results in Excel vs. Python

To calculate the date difference, we can ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
361 views
0 votes
1 answer

Convert Date format into DD/MMM/YYYY format in SQL Server

Using convert() and style 106, you can ...READ MORE

answered Feb 23 in Database by Vaani
• 7,020 points
5,577 views
0 votes
1 answer

Excel - Combine multiple columns into one column

In Excel, how can I concatenate (combine) ...READ MORE

answered Mar 30 in Database by gaurav
• 22,040 points
957 views
0 votes
1 answer

Remove time from date field in Excel formula

Use the Find And Replace function to ...READ MORE

answered Mar 30 in Database by gaurav
• 22,040 points
146 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP