Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel Question - Separating Data?
I imported data via csv into excel. In column A, the data is the date and time: For instance 12/13/14 13:54. This needs to be in two columns. Column A is the date, Column B is the time. How can I take the data from one column and separate it into two?
2 Answers
- Greg GLv 76 years ago
There are a couple of options.
1. Text to Columns
Select your data, that the Data tab and click on Text to Columns.
Select FIXED WIDTH
Now adjust the left most line so that it's right in front of the first digit in the time.
Delete (by double clicking) the right line so that AM or PM isn't split from the time.
Click Finish
This, however, has the unwanted effect of leaving 0's in the time place in the original column.
Option 2:
Use the DATE and TIME functions in the next two columns:
=DATE(YEAR(A1), MONTH(A1), DAY(A1))
=TIME(HOUR(A1), MINUTE(A1), SECOND(A1))
Format the column with the TIME formula as your choice of time displays. The column with the DATE formula should auto format to mm/dd/yyyy.
Once you do this, if you need to put the data into column A and B, simply select the data in columns B and C, copy it, then select column A, and select Paste Special >> Values.
This will paste the info into columns A and B. Now just delete column C.
- 6 years ago
Greg, the first one worked fabulously, but now is their a way to delete the 0:00 from the date column? I don't understand the option 2?