TEXTSPLIT is a very useful function for breaking down text cells that contain different lengths ... where data appears in a single text string, and we want it to be shown in multiple columns and rows.