Flash Fill – Excel
If you have a column containing first names AND last names, it is hard to sort or otherwise just work with the last name. Excel 2013 provides a neat feature called Flash Fill to copy out just the last name. You don’t have to be an Excel expert to use it. Just type!