How it works
This function allows the user to split the contents of each cell in a column based on the first instance of a delimiter into two new columns.
A delimiter is a character or sequence of characters used to specify the boundary between separate, independent regions of text or data. Common delimiters include commas (,), tabs, spaces, or other symbols like semicolons (;) or pipes (|). For example, in the text ‘apple,banana,cherry,’ the comma is the delimiter that separates the words.
How to use it:
Step 1
In the ‘More’ drop down of the Cleaning and Structuring group, click on ‘Split Column’.
A new pop-up window will appear.
Step 2
Select the cell or the column to be split.
Step 3
Type the delimiter to be used as the split point. In the Example a Space is used.
Note: The delimiter will be deleted from the results
Step 4
Click on OK to run the function.
Step 5
The results will be populated into two new columns, while retaining the original column.
