=TEXTSPLIT
https://www.ablebits.com/office-addins-blog/textsplit-function-excel-split-cells-strings/
Basic TEXTSPLIT formula to split a cell in Excel
Split a cell horizontally across columns
Split a cell vertically across rows
Split string into columns and rows at once
Separate cells by multiple delimiters
Split text ignoring empty values
Cell splitting case-sensitive or case-insensitive
Pad missing values in 2D array
Split dates into day, month and year
Split cells and remove certain characters