Help

Separating string of text based on commas

Topic Labels: Formulas
183 1
cancel
Showing results for 
Search instead for 
Did you mean: 
cathdres
4 - Data Explorer
4 - Data Explorer

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!

1 Reply 1

You can convert your text field into a linked record field, and all of those values will become their own records in another linked table.