Worked like a charm! Thank you

This response is really helpful! The challenge I’m running into is that many of the people on my spreadsheet have multiple last names. Which means that when I use this formula it only pulls out the very first and very last names listed. For example: ...

Agreed! I don’t see any response here from Airtable admins. Is this something we could get insight on? Are you considering adding this feature? Can we get a notification on this thread as to whether you’re working on it or not?