Final answer:
To convert comma-separated values to a list in Excel, use the 'Text to Columns' feature and specify the delimiter as a comma.
Step-by-step explanation:
To convert comma-separated values to a list in Excel, you can use the 'Text to Columns' feature. Here's how:
- Select the cell or range of cells that contain the comma-separated values.
- Go to the 'Data' tab and click on the 'Text to Columns' button.
- In the 'Convert Text to Columns Wizard,' select the 'Delimited' option and click 'Next.'
- Choose the delimiter of your values (in this case, a comma) and click 'Next.'
- Specify the data format for each column and click 'Finish.'
Excel will then convert the comma-separated values into separate cells, effectively creating a list.