Forum Discussion
VL852455
Feb 25, 2020Copper Contributor
Split cell by delimiters
Hello I am planning to capture some structured text, as MS Form has no tabular input, I created a multiline text question. And the text responses will be like: 3 dummy responses, and text ar...
Abiola1
Feb 25, 2020MVP
1. Select the column
2. Click on Text to column
3. Select Delimiter
4. Check semicolon
5. Click on Next
6. Select Destination cell
7. Click Finish
You should have it split into three columns
2. Click on Text to column
3. Select Delimiter
4. Check semicolon
5. Click on Next
6. Select Destination cell
7. Click Finish
You should have it split into three columns