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!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s