The Text to Date tool quickly converts text strings that look like dates into true Excel dates so you can sort, filter, or use them in formulas and PivotTables afterwards. Read this guide to know how to work with Text to Date in Excel.
There are some things you should keep in mind before using the tool:
To run the tool, go to the Date & Time group on the Ablebits Tools tab and click Text to Date:
The Text to Date pane appears:
To alter the range, enter the needed address manually or click the rightmost icon in the field. In the latter case, the Select Range dialog box will open allowing you to pick the necessary range:
Click Convert and get the result inserted to the right of your original column.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!