Separating Contacts column into First and Last name

Hello,

We set up a Contacts board as part of the Basic CRMs feature. Is there a way to separate the contact column - someone’s full name - into a First and Last name column through an automation? Thank you!

Hi! As outlined in this post, you can separate them through two formula columns.

The first column should contain this formula:

LEFT({Name}, SEARCH(" ", {Name})-1)

And the second column should contain this one:

RIGHT({Name}, LEN({Name})- SEARCH(" ", {Name}))

Thank you! Is there a way to adjust the formula to capture middle names or first names with two names?