-
pbwithewAsked on June 6, 2014 at 2: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
-
Elton Support Team LeadReplied on June 6, 2014 at 5: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!