Hi @sierr146,

Apologies for missing that! We don’t currently have a function/formula that will split out the multiple values from a multi-select column, so it won’t be possible to extract each first name from multiple contacts in a multi-select column. I found two similar product ideas below:

• Add function to retrieve values from cell for a multi-select column
• First Name, Last Name fields for Contacts

Please add your vote to these ideas if they match your request. You’ll then receive updates when the status of the idea changes! 

An alternative solution would be to have multiple single-select contact list columns, so that you list one contact in each column, and then use a similar formula to the one I provided before, but adding it again to look at your second column (and adding it again if you’ll have 3 contact columns, and so on), for example:

• =LEFT(Name@row, FIND(" ", Name@row)) + ", " + LEFT(Name2@row, FIND(" ", Name2@row))

Hope that helps!

Georgie