Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2378449%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378449%22%20slang%3D%22en-US%22%3EHello!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20a%20beginner%20fixing%20a%20downloaded%20csv%20document%20to%20be%20run%20through%20an%20R%20script.%20To%20have%20the%20data%20properly%20formatted%2C%20I%20need%20date%20and%20time%20in%20a%20single%20column%20(mm%2Fdid%2Fyyyy%20hh%3Amm%3Ass)%20in%20addition%20to%20year%2C%20month%2C%20day%2C%20hour%2C%20minute%2C%20and%20second%20each%20residing%20in%20their%20own%20column.%20The%20date%20and%20time%20in%20a%20single%20column%20came%20with%20the%20original%20download%20of%20the%20data.%20How%20am%20I%20able%20to%20pull%20the%20individual%20year%2C%20month%2C%20day%2C%20hour%2C%20minute%2C%20and%20second%20individually%20from%20the%20downloaded%20source%20(mm%2Fdid%2Fyyyy%20hh%3Amm%3Ass)%20and%20paste%20each%20in%20their%20own%20column.%20I%20have%20attached%20a%20picture%20of%20what%20I%20need%20my%20data%20to%20look%20like.%20As%20of%20now%2C%20my%20local%20time%20column%20is%20the%20same%20but%20I%20do%20not%20have%20any%20data%20in%20y%2C%20m%2C%20d%2C%20h%2C%20m%2C%20s.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2378449%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2378590%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378590%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1060829%22%20target%3D%22_blank%22%3E%40Jakeyharvey23%3C%2FA%3E%26nbsp%3BSee%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fexcel%2Fm-p%2F2378444%22%20target%3D%22_self%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fexcel%2Fm-p%2F2378444%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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