How to Split Text in Cells with Flash Fill in Excel

In this video, I show you how to use the Flash Fill feature in Excel to split full names into first and last names. Flash fill is an intuitive resource that guesses what you want in your column based on one or more examples.