Excel Split Column
|
 |
|
The idea here is that you have imported or copied information into Excel. For
an example the first
and last names are in one column. You want to separate them. First name in one column and
the last name in another column.
Now select the column - just the one column with the first and last names.
Select: Data, Text to Columns...
Click the Next button in the dialog box
In the next step check to make sure Space is selected as the separator.
Then click finish button.
Now you can sort by last name or the first what ever.
Bottom line, you split the column.
| 
