Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

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: https://www.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!:
https://www.youtube.com/watch?v=PdB6Lt2a7Ko

Dynamic Array Formulas and Spill Ranges in Excel Tables: https://www.youtube.com/watch?v=irR9bUKzTw8

How to Split Text in Cells with Flash Fill in Excel:
https://www.youtube.com/watch?v=JigehyeACcw

#MsExcel #ExcelCampus