Excel 2016's AI knows your names
There's a pretty cool new feature in Excel 2016 which will help you when editing names entered in a column.
If you have column of names in 'first name last name order', and then begin to enter them in 'last name, first name' order in the adjacent column, Excel 2016 will see what you're trying to accomplish, and will suggest the results for all of the names you're editing:
Just press enter to accept them. Works the other way around too!