Channel: Excel Campus - Jon

Category: Education

Tags: excelexcel tips and tricksexcel new formulasexcel textbeforesplit textexcel textsplitexcel textafterexcel textsplit functionexcel campusexcel split text in celltextsplit

Description: In this video, you can learn the pros and cons of the new text splitting functions in Excel. If you’d like to read the accompanying blog post on my website, you can access it here: excelcampus.com/functions/textsplit-vs-textbefore-textafter 0:00 TEXTSPLIT 2:54 TEXTBEFORE & TEXTAFTER 4:28 Multiple Delimiters 5:44 Start with the First Name 5:51 Take care of the Last Name 6:35 Identify the Middle Name(s) 8:05 Splitting Other Types of Text 9:06 Splitting into Rows Instead of Columns 9:35 Splitting into Rows AND Columns Related Videos: 14 NEW Excel Functions - TEXTSPLIT, Array Shaping, and more!: youtube.com/watch?v=PdB6Lt2a7Ko Dynamic Array Formulas and Spill Ranges in Excel Tables: youtube.com/watch?v=irR9bUKzTw8 How to Split Text in Cells with Flash Fill in Excel: youtube.com/watch?v=JigehyeACcw #MsExcel #ExcelCampus