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

    Excel: Separate cell values into columns

    Asked by kaleidoscopecreations on April 26, 2014 at 07:01 PM
    Now if I can figure out how to give each state in a single submission it's own row so I can just click AZ sort to make it easier to tally them up!
  • Profile Image
    JotForm Support

    Answered by EltonCris on April 26, 2014 at 07:02 PM

    Sorry, I have moved your question into a separate thread since this question does not relate to your previous one. Please find my response below.

    @kaleidoscopecreations 

    You can actually separate each value on a cell into each column.

    Check this thread to find out how it is done. http://www.jotform.com/answers/214003-Separating-purchased-products-in-Excel-export-of-submission-data#214037

    Let us know if you have further questions or if you need further assistance.

    Thanks!

  • Profile Image

    Answered by kaleidoscopecreations on April 26, 2014 at 07:43 PM

    Thank you! I will try that. :)

  • Profile Image

    Answered by kaleidoscopecreations on April 26, 2014 at 07:59 PM

    I think it's over my head. LOL

  • Profile Image

    Answered by kaleidoscopecreations on April 26, 2014 at 08:36 PM

    I found another set of directions that were easier for me to understand but I don't have regular excel. I have excel starter and I've tried google sheets and in neither one can I find text to columns.

    I don't think this is going to work for me but thanks anyway.

  • Profile Image
    JotForm Support

    Answered by jonathan on April 26, 2014 at 11:01 PM

    Hi,

    Thank you for updating us and we aplogize for the delayed response.

    Are we good to assume that you had found the resolution?

    Please inform us if you need our assistance further.

    Thanks!

  • Profile Image

    Answered by kaleidoscopecreations on April 27, 2014 at 10:20 AM

    The problem is, neither excel that I have access to will work with this method. There's no 'text to columns' option I can find.

    However, I am VERY happy to say I found the easiest solution of all right on the submissions page! For my particular form it works.  I just have to put the name of the state in the search bar at the bottom and it tells me how many submissions were made for that state. The counting is done for me and no sorting!

    Thanks!!

  • Profile Image
    JotForm Support

    Answered by BrianPaulo on April 27, 2014 at 12:35 PM

    @kaleidoscopecreations,

    Sorry it didn't work on the version of MS Excel you have installed on your computer and we are happy that you find another work around that suits your needs. With that being said, are we okay to assume that you're good to go?

    Let us know if there's anything else we can do for you.

    Bryan