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:
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
Excel: How to Count If Cells Contain Text
Excel: How to Use COUNTIF with Multiple Ranges
Excel: How to Count Unique Values Based on Multiple Criteria
