Channel: Excel Campus - Jon

Category: Education

Tags: how to divide one cell into two in excelhow to separate text and numbers in excelhow to use the split function in excel vbahow to separate columns in excelconvert text file to excelhow do you split a cell in excelhow to separate first and last name in excelexcelexcel split functionexcel campusseparate cells into columns excelhow to separate words in excelhow to split cells in excelhow to split one column into multiple columns in excel

Description: 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: 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: youtube.com/watch?v=8wXt6KrQOLY Split Cells with Text to Columns in Excel: youtube.com/watch?v=9barqPO2pvg #MsExcel #ExcelCampus