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:

excel-nameflashfill-20180920-1

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:

excel-nameflashfill-20180920-2

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

excel-nameflashfill-20180920-3

Same thing works for the Last Name:

excel-nameflashfill-20180920-4

Like so:

excel-nameflashfill-20180920-5

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 )

Google+ photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s