Split Columns window |
Top Previous Next |
The Set the separator to the text you wish to split the column(s) at. Select every to split at every occurrence of the separator token and the first to only split at the first occurrence. Click OK to split the column(s) and close the window. Click Cancel to discard the changes. Splitting creates new columns to the right of the column(s) being split. The new columns are selected. The original column(s) is/are not changed. For example "John Smith, CEO, Smith industries - UK" could be split into columns as follows:
You can carry out as many split and join operations as you need to get your data into appropriate columns.
See also: |