How many times have you encountered an Excel spreadsheet where the first and last names were in two different columns and you needed to combine them? Or, perhaps you need to do the reverse. Yes, Excel contains formulas that will handle these sorts of tasks. I don’t use those functions enough to remember the formulas and find myself looking them up.

A great new feature in Excel 2013 called “Flash Fill” makes tasks such as these easy. This video by Mike Thomas demonstrates this new feature.

If you think others would benefit from seeing this video, please click on one of the social media icons below to and share this post.