In this video I demonstrate how to split text by delimiter. If you have imported text into Excel that needs splitting into rows and / or columns, you can now use the TEXTSPLIT function. TEXTSPLIT is available to Excel 365 users.

00:00 Introduction
00:05 Split comma separated data into columns
01:07 Split text into rows and columns using delimiters
01:51 Specify multiple delimiters for rows or columns
02:33 Dealing with missing data (empty cells)
03:38 The TEXTSPLIT 'Pad with' argument
04:24 Case sensitive vs insensitive
------------------------