Automatic column splitting
Split columns into multiple pieces based on a delimiter.
Splitting a column of data into separate parts (e.g. splitting email addresses into username and domain) can be highly manual/time-consuming using “text-to-columns” in Excel.
Use a “Column Split' object to split a column based on a delimiter. For example you can split an email address into username and domain based on the “@” symbol.