Oct 19 2020 02:33 AM
hi,
I am struggling to convert text into date. Attaching an excel for getting some support.
Oct 19 2020 03:22 AM
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.