Excel Flash Fill on names

I’m sitting in a training session today, and I saw the trainer do something in Excel that I didn’t know was possible… Flash Fill can complete columns of names based on other columns. Here’s how…

I have an Excel table with a list of Full Names, followed by columns for First Name and Last Name:

If I enter the first name (Tom) of the first entry (Tom Duff) in the First Name column, I can then click on the cell underneath it and click on Flash Fill:

Hey! It filled in all the first names from the Full Names column:

Same thing works for the Last Name:

Like so:

This is REALLY cool as I don’t have to come up with any formulas to make that happen for me!