How to get selected categories into a separate cell in excel

  • Profile Image
    Tracipma
    Asked on January 29, 2018 at 07:55 AM

    On the form PMA Shows bridal registry, I ask the bride what she still needs, then she can choose from several things, I'd like each selection to go into its own cell when I download it into an excel worksheet.  What do I need to do on the form or change to accomplish this?


    Thank you

  • Profile Image
    EltonCris
    Answered on January 29, 2018 at 10:47 AM

    As of the moment, there's no setting to change its format before downloading it to Excel.

    However, there's a workaround using your MS Excel application. You can separate them using the Text to Columns function found in the Excel app.

    This guide will help: http://www.excel-easy.com/examples/text-to-columns.html