TEXTSPLIT is used to split text by using column and row delimiters in Excel. This function can enable you to split the text across column