If you have data that appears all in one column, CSV.SPLIT can help you split comma separated values into separate columns.
This is function is local in a specific workbook, using the function LAMBDA. Copy a cell using the function and paste it in another workbook, and it follows.
Opposite to joining text strings but the syntax is setup similarly;
TEXTJOIN(delimiter, ignore_empty, strings)
CSV.SPLIT(delimiter, if_empty, string_anchor, chose_columns). Only the anchor is mandatory.
As of April 2022, Microsoft has began distributing a new function that pretty much handles the same matter;
TEXTSPLIT(range,delimiter) that below looks like TEXTSPLIT(A2:A10, ",")