- JotForm SupportMike_GAnswered on April 24, 2016 at 02:46 PM
There are two ways actually.
First, with the help of "Split Text to Columns".
This would require you to add one additional column on the right of the column you want data to split.
Then, under Data(from the Menu bar) click the "Split Text to Column" option. Then, leave the separator as "Comma".
Second, would be with the help of "=SPLIT()" function.
This would, however, require you to add two columns on the right and will leave the original column that holds the data you want to split.
Here's how it works: "=SPLIT("TEXT OR CELL YOU WANT TO SPLIT", "DELIMITER")"
Then, you can just hide the column that shows the unsplit data.
I hope this helps. Let us know if you need any further assistance. Thank you.