Format Dates and Numbers Correctly, Extract Data using Text to Columns

This video shows other uses of Text-to-Columns Delimited. We can use it to format dates correctly (if date is not recognized by Excel as date, instead as text) and you need to convert them into date format. We can also use it to convert different regional formats of numbers instead of NUMBERVALUE. Finally, we will use it to extract specific parts of a data instead of formulas.