What is the TEXTSPLIT function in Excel 365 and what makes it more powerful than Text to Columns?

Question

Microsoft Excel — Hard

What is the TEXTSPLIT function in Excel 365 and what makes it more powerful than Text to Columns?

Accepted Answer

The TEXTSPLIT function in Excel 365 offers advanced text manipulation capabilities. It surpasses Text to Columns by splitting text into a 2D array using both column and row delimiters. This flexibility, along with options for handling empty segments and padding, makes TEXTSPLIT more powerful. Its formula-based nature also avoids overwriting adjacent cells.