Is there a way to manage Checkbox output?

  • Profile Image
    pbwithew
    Asked on June 06, 2014 at 02:20 AM

    I am making a registration form for a retreat. I have a checkbox field asking users to indicate all the days they will be staying -- eg, Monday, Tuesday, Wednesday, Thursday, Friday. When I output the data into Excel, the data from this field comes concatenated in one cell. For example, MondayWednesdayFriday. I am finding it difficult in Excel to manipulate this text. It would be easier if the data were dumped into separate columns, or at least, if there were a comma or space between each day -- then I could manipulate them better in Excel. Any words of wisdom?

    Thanks,

    Peece

  • Profile Image
    EltonCris
    Answered on June 06, 2014 at 05:51 AM

    Hi Peece,

    Here's a way on how to separate them per column using your Excel program, hopefully this workaround will help.

    http://www.jotform.com/answers/290516#290557

    Let us know if you need further assistance.

    Regards!