Format Dates and Numbers Correctly, Extract Data using Text to Columns
Excel Insights Excel Insights
6.32K subscribers
471 views
0

 Published On Oct 17, 2023

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.

show more

Share/Embed