Text to Columns

You can divide up a string of text in a cell into many by using spaces, tabs, commas, colons, or other characters.

You can treat multiple separators that are placed together as one separator if you select Treat Consecutive Separators as One.

To divide text with comma

1. Select the cells to divide the text and click Data-Text to Columns.
   In this example, select a cell with comma (e.g.: 500, 1000).
2. In the Text to Columns dialog box, select Comma under Separator and click OK.
3. The text that was contained in a single cell will be divided into multiple cells separated by the separator.

Notes

Text to Columns Dialog Box

Separator

Enter in each cell by separating strings based on a separator such as a tab, semicolon or space. You can treat multiple separators that are placed together as one separator if you select Treat Consecutive Separators as One.

Preview

Preview the result.

OK Button

Close the dialog box and paste the contexts into the cell according to the selected criteria.

Cancel Button

Close the dialog box. This will discard the changes.