Home Excel 2002 Columns Separating Information In Columns
Search MS Office A-Z | Search Web Pages/ Design A-Z
Separating Information In Columns
To separate information in one column into separate columns:
- Select the column that contains the information you want to separate.
- Click Data | Text To Columns | Delimited, and click Next.
- In the Delimiters box at the top of the Convert Text To Columns Wizard window, designate what you want Excel to use as an indicator for a new column. For example, if you want to separate brown, black, yellow, and green, you’d select Comma. This tells Excel to place information separated by commas into separate columns.
- Click Next and Finish.