Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video, I show you how to use formulas in Excel to split full names into first and last names. I use functions such as RIGHT, LEFT, SEARCH, and LEN to do this.
If you’d like to read the accompanying blog post on my website, you can access it here: https://www.excelcampus.com/functions/split-cells-formulas

0:00 Intro
1:12 Extract First Name
5:14 Extract Last Name
8:33 Pros & Cons of Formula Technique

Related Videos:
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