I have a string of text in one column that i'd like to separate into individual columns. For example:
Row 1: K, 1st, 2nd, 3rd, 4th, 5th, 6th
Row 2: preschool (ages 4+), K, 1st, 2nd, 3rd, 4th, 5th, 6th, 7th, 8th
Row 3: ages 3+, preschool (ages 4+), K, 1st, 2nd, 3rd, 4th, 5th
For my existing Row 1, I want a formula that will return each in its own column:
K
1st
2nd
3rd
4th
5th
6th
As you can see, the length of characters isn't consistent, but the comma consistently separates the fields I want. How can I use the comma to separate out the text? I've found a way to extract the text before the first comma (LEFT({selection 4}, FIND(",", {selection 4}) -1), but can't figure out the rest. Thanks in advance!
