Split Data (Text or Number) By Delimiter into Rows and/or Columns Using TEXTSPLIT Formula

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
------------------------

[panigrahiruchika]

I am so glad that i found your services here. Its is very useful for us sir, Thank you for presenting it clearly.

[IvanCortinas_ES]

Excellent tutorial Chester. Very interesting the use of the TEXTSPLIT function. Thank you!

[balajiraog]

Thanks a lot for sharing that we can use multiple delimiters And split into rows too. 👏✌

[usmaniqbal]

Perfect 👍 Sr, please share excel workbook for practice

[teoxengineer]

Thank you for this useful tutorial.
Let’s assume that we want to keep signs like “=“ or “-“ or “:” in the cell and to split this text before numeric value.
How can we arrange it?

[larrywheeler]

Most helpful. I figured out how to TEXTSPLIT to rows for one cell of comma delimited words/terms. I have approx. 1, 000 records with cells that have words/terms separated by commas. Does TEXTSPLIT allow a cell range so the formula can be applied to all cells in a column? I can't seem to make it work with a formula like =TEXTSPLIT(C2:C999, "NULL", ", ") where I want to ignore the col_delimiter by using "NULL" and just use the "row_delimiter" which is ", ". The logic works for one cell, but not working when I try to specify a range of cells.

[shoaibrehman]

Hi Sir, could you pls explain how 1 column data let say 100 rows, i have to split into 10 columns, each column contains 10 rows.

[omprakashthakur]

Hello sir using another function how can I split as same please sir reply with answer

[jamesbond]

need help
let's say cell A has the following data: [abd200/201]
i want a function or formula that would return in, say cell B: [abd200], and in cell C: [abd201].
meaning, cell B = data before the "/" and cell C = data after the "/" but with the letters before the "/" prefixed to it.


is that a possibility without using code?

thanks

[SirCharlesLikesChurros]

Still waiting for this function and the textbefore/after to be release to 365 users 😔