- pbwithewAsked 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?
- JotForm SupportEltonCrisAnswered on June 06, 2014 at 05:51 AM
Here's a way on how to separate them per column using your Excel program, hopefully this workaround will help.
Let us know if you need further assistance.