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
- 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). - In the Text to Columns dialog box, select Comma under Separator and click OK.
- 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.