Question

How to convert comma-separated values to list in Excel?

Answer 1

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:

1. Select the cell or range of cells that contain the comma-separated values.
2. Go to the 'Data' tab and click on the 'Text to Columns' button.
3. In the 'Convert Text to Columns Wizard,' select the 'Delimited' option and click 'Next.'
4. Choose the delimiter of your values (in this case, a comma) and click 'Next.'
5. 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.