- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 22, 2024 04:03 PM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 22, 2024 04:53 PM
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.
