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

Amazing

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.

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.

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

I don't have this in my excel😑

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

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

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

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

Perfect 👍 Sr, please share excel workbook for practice

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?