Join Columns window |
Top Previous Next |
The Set the order to the order you wish to join the column(s) in. Set the separator to the text you wish to join the columns with. Select ignoring empty cells to ignore empty cells. Click OK to join the columns and close the window. Click Cancel to discard the changes. Joining creates a new column to the right of the columns being joined. The new column is selected. The original columns are not changed. You can carry out as many split and join operations as you need to get your data into appropriate columns.
See also: |