Multiple-choice data in Excel: can we display the data in separate columns?

All the choices are displayed in a single column, separated by a comma (“,”).

As a workaround, you can split the data in different columns using Excel: Select the cells, go to Data –> Text to columns –> Choose “Delimited” in the pop-up window, then choose a delimiter (a semi-colon or a comma) and your data will be parsed into separate columns.

← Return to search results