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

[@panigrahiruchika7688]

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!

[@imahodler]

Amazing

[@usmaniqbal1836]

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?

[@larrywheeler9106]

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.

[@shoaibrehman9988]

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.

[@jamesbond3495]

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

[@omprakashthakur4515]

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

[@SirCharlesLikesChurros]

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

[@pinklover1569]

I don't have this in my excel😑

[@traceyjames4681]

Please look for the latest updates!