is there a way to split a list into separate columns? I want the list “UK, Macedonia, Germany” split by the comma and place each each item in a separate column.
Hmm, I don't think there's another option but to create several formula columns to extract the words based on the position they appear in. Example:
1. Returns the first word
2. Returns second word
3. Returns third word...