Table of Contents
To split a string by comma in Excel, you can use the “Text to Columns” feature. This feature allows you to separate a cell or range of cells into multiple columns based on a specified delimiter, such as a comma. This can be useful for organizing data or extracting specific information from a cell. To access this feature, go to the “Data” tab and click on “Text to Columns.” From there, you can select the delimiter and choose how you want the data to be split. This feature saves time and effort compared to manually separating the string by commas.
Split String by Comma in Excel
You can use the Text to Columns function within the Data tab in Excel to split a string into multiple columns based on where commas appear in the string.
The following example shows how to do so in practice.
Example: How to Split String by Comma in Excel
Suppose we have the following list of attributes for various basketball players in Excel:
Suppose we would like to split each string into separate columns based on where commas appear in the strings.
To do so, we can highlight the cell range A2:A7, then click the Data tab along the top ribbon, then click the Text to Columns icon within the Data Tools group:
In the new window that appears, check the box next to Delimited, then click Next:
Then check the box next to Comma, then click Next:
Then type $B$2 in the Destination box, then click Finish:
Each string in column A will automatically be split into new columns based on where the commas appear in the strings:
