Excel

New Contributor
Hello!

I am a beginner fixing a downloaded csv document to be run through an R script. To have the data properly formatted, I need date and time in a single column (mm/did/yyyy hh:mm:ss) in addition to year, month, day, hour, minute, and second each residing in their own column. The date and time in a single column came with the original download of the data. How am I able to pull the individual year, month, day, hour, minute, and second individually from the downloaded source (mm/did/yyyy hh:mm:ss) and paste each in their own column. I have attached a picture of what I need my data to look like. As of now, my local time column is the same but I do not have any data in y, m, d, h, m, s.
1 Reply