Have you ever had a column of data in Excel (like full names) and wanted to split out the first name into one column and the last name into another? Furthermore, are you less than adept when it comes to formulas in Excel? Perhaps the Flash Fill feature can be your knight in shining armor! Here’s how that works…

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…