Practical use of row_delimiter with TEXTSPLIT

Hi,

See the screenshot above. In cell E2 I have apply this formula:

=IFNA(TEXTSPLIT(TEXTJOIN(";",, B2:B6), ", ", ";"), "")

This part of formula TEXTJOIN(";",, B2:B6) combines all the texts into a single cell, placing a semicolon for each text of each row (in the meantime, see that in cell B3 a comma is placed after the first name of this cell).

Now we have a single text that contains two different separators (comma and semicolon).

Through the TEXTSPLIT function we can split the text into different columns and rows based on the separators. The separator ", " serves to separate the texts into columns and the separator ";" serves to separate the texts into rows.

Finally, the texts will be placed in different columns and rows.

The use of the IFNA function is done to remove #N/A from the final results.

To better understand, apply the formula step by step.

I hope I have explained the use of separators for the TEXTSPLIT function.

Regards,

IlirU