Use Excel’s Text-to-Columns Tool to Quickly Correct Date Entries

The Text-to-Columns tool in Excel is one of my favorites. I use it to quickly “parse” text elements in a cell. For example, to separate “First Name” from Last Name in a cell that contains the “Full Name” entry.

In this short – 3 minute, 23 seconds – video, I demonstrate another way to use Text-to-Columns. I show you how to separate the “Year,” the “Month” and the “Day.” A client called me in a panic – they downloaded daily transactions from their mainframe computer into Excel. However, the “dates” appeared as – e.g. 20100901 – and they could not find a way to format the dates as – e.g. 9/1/2010

Learn how to “Master Excel in Minutes – Not Months!”

Use Excel Text-to-Column Tool to Correct Date Entries [ 3:23 ] Play Now | Play in Popup | Download (829)