Excel Flash Fill

From time to time you have annoying things to do which you cannot avoid e.g. split names into surname and last name. Here comes the flash fill feature: Given you have the full names in column A Go to cell B1 and enter the last name Go to B2 Go to tab “Data” Click Flash…