Date vs. text

%3CLINGO-SUB%20id%3D%22lingo-sub-1794858%22%20slang%3D%22en-US%22%3EDate%20vs.%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1794858%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20struggling%20to%20convert%20text%20into%20date.%20Attaching%20an%20excel%20for%20getting%20some%20support.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1794858%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1794987%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20vs.%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1794987%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F796836%22%20target%3D%22_blank%22%3E%40Nishantu309034%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20do%20this%2C%20select%20the%20whole%20column%20B%2C%20go%20to%20Data%20Tab%20and%20click%20on%20Text%20to%20Columns%20under%20Data%20Tools%20Group%20and%20then%20in%20the%20next%20window%20select%20the%20first%20option%20Delimited%20and%20click%20on%20Finish.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERefer%20to%20the%20following%20screenshot.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22TextToDates.jpg%22%20style%3D%22width%3A%20510px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F227656iAEA9CB3CCC86F6AF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22TextToDates.jpg%22%20alt%3D%22TextToDates.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

hi, 

 

I am struggling to convert text into date. Attaching an excel for getting some support. 

1 Reply

@Nishantu309034 

To do this, select the whole column B, go to Data Tab and click on Text to Columns under Data Tools Group and then in the next window select the first option Delimited and click on Finish.

 

Refer to the following screenshot.

TextToDates.jpg