Splitting a Column
You can split a column into several columns by separators, field lengths, and conditions.
Use one of following functions to split a column into several columns:
- Split into Several Columns
Use this function to split a column by separators and field lengths, which are two basic methods used to split a column.
- Split Columns by Condition
Use this function to add conditions when splitting a column. Only the cell values that conform to the specified condition are split according to your configuration.
- Split Columns and Reorder
Use this function to specify names and arrange orders for split columns.
- Split by separator
You can split a column by a separator, which is any separator contained in the cell values of the column that you are splitting.
To use a regular expression as a separator, select the Regular expression check box.
In the Max columns field, you can also specify the number of columns into which the specified column is split . If no value is entered, it indicates that there is no limit. - Split by field lengths
You can split a column by the number of characters contained in cell values. Numbers are separated by comma (,). You can use this function when the cell values do not contain any separator or a fixed separator.
