From Dev.to
Split and Combine Text in Excel With TEXTSPLIT and TEXTJOIN (Examples)
To split text in Excel, use TEXTSPLIT: give it a column delimiter such as a comma to spread a cell across columns, or a row delimiter to send the pieces down rows, and list several delimiters in curly...