Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
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.
If you’d like to read the accompanying blog post on my website, you can access it here: https://www.excelcampus.com/tables/split-cells-flash-fill

Related Videos:
How to Split Text in Cells Using Formulas: https://www.excelcampus.com/functions/split-cells-formulas

How to Split Cells & Text in Excel with Power Query:
https://www.youtube.com/watch?v=8wXt6KrQOLY

Split Cells with Text to Columns in Excel: https://www.youtube.com/watch?v=9barqPO2pvg


#MsExcel #ExcelCampus
00:00 Introduction
01:16 Flash Fill
03:28 Another Example
04:13 Complex Example