I have a Multi-Select column labeled Email that allows users to select multiple email addresses populated from an external Sharepoint list. I then get their choices and update a single-text column with their choices, commas delimited. This is what that column contains for example:
What is the best method to separate each email without the colon into different columns? I have tried looking into different functions using Calculated Columns, but I'm not sure how to handle more than two email addresses.