Namethat contains the first and last name separated by a space.
Dataframethat contains the column you want to split.
Columnthat you want to split.
Delimiterssection to build the delimiter that you want to separate on. If you select multiple delimiters, either of them will trigger a split.
Columns Previewshows you the first three rows of the new columns you will create by splitting using the current configuration of the taskpane.
Split on delimiterbutton and notice the new columns in your sheet.