What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to delimit checkbox/radio data in Excel

    Asked by welstechtrainer on February 03, 2014 at 11:13 AM

    Hi - 

    When I include a checkbox field on my form all of the submitted data is stored in the same cell in Excel with no delimiter for parsing. Is there a better way to gather that type of multiple choice, many-option data so that is is easier to manipulte in Excel? Thanks!

    checkbox excel checkbox field multiple choice delimit excel delimit
  • Profile Image
    JotForm Support

    Answered by EltonCris on February 03, 2014 at 12:08 PM

    Hi,

    New lines/Line breaks can be easily assigned with delimiter on excel. Just use the following formula. I have used ^ as the delimiter.

    =SUBSTITUTE(B2,CHAR(10),"^")

    Now, after assigning delimiter, copy the results and paste it as values (Home --> Paste --> Paste Values) to remove its formula.

     

    You can then separate each values by column if you want by using to Text to Columns tool. Here's an example:

    Enter delimiter symbol.

    Hope this helps. Thank you!

  • Profile Image

    Answered by welstechtrainer on February 05, 2014 at 08:50 AM

    Perfect! Thanks for your help.