Extract text without a formula – Flash Fill
In Excel 2013 and later, you can extract text without a formula using Flash Fill.FlashFill is a tool integrated into Excel, that runs in the background continuously.
extract text
Convert a Text Date to a Number Date
How to convert Text Date to Numerical Date? For this Excel is the best tool to do the job, and there is two techniques.