Use AutoFill/Flash Fill in Excel 2013

Sometimes you need to enter a lot of repetitive information in Excel, such as dates, and it can be really tedious. But the AutoFill feature can help. Or say you have information in Excel that isn’t formatted the way you need it to be, and going through the entire list manually to correct it is daunting. In this case, Flash Fill (introduced in Excel 2013) can do the work for you.

Use Flash Fill, new in Excel 2013, to fill out data based on an example. Flash Fill typically starts working when it recognizes a pattern in your data, and works best when your data has some