How to separate check box selections in excel spreadsheet report

  • Profile Image
    drwilburne
    Asked on September 26, 2016 at 10:32 AM

    Is it possible for the excel spreadsheet to separate selections with a comma when a user submits an answer with more than on answer? Example: Please select all counties that you serve. Mifflin, Juniata, Dauphin, Philadelphia, etc...



    This is a re-post of a comment on How to Create an Excel Report?

  • Profile Image
    Irshad
    Answered on September 26, 2016 at 12:20 PM

    The selected options are wrap in the excel report by default. Please check the screenshot below:

    If the above output won't work for you, please try using our asmSelect Widget: http://widgets.jotform.com/widget/asmselect. This widget will give you a comma separated values.

    Here's -How-to-Add-a-Widget-to-your-Form.

     

    If you have any query, or need further assistance, feel free to revert back.

    Thanks.