Separating Contacts column into First and Last name

[Nadya-Opsters (Nadya)]

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}))