TEXTSPLIT function - Microsoft Support
https://support.microsoft.com:443/en-us/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7
WEBOptional. pad_with The value with which to pad the result. The default is #N/A. Remarks. If there is more than one delimiter, then an array constant must be used. For example, to split by both a comma, and a period, use =TEXTSPLIT (A1, {",","."}). Examples. Copy the example data and paste it in cell A1 of a new Excel worksheet.
DA: 23 PA: 74 MOZ Rank: 37