TEXTSPLIT function - Microsoft Support
https://support.microsoft.com/en-us/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7
webSplits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows. It is the inverse of the TEXTJOIN function . Syntax. =TEXTSPLIT (text,col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])
DA: 60 PA: 78 MOZ Rank: 81