Separating Contacts column into First and Last name

@JCorrell Hi ! I saw some other formulas you wrote on other threads, but none of those worked.


We need a last name - with only the last name, is there a way to do this? Currently in this snip: RIGHT({Name}, LEN({Name})- SEARCH(" ", {Name})) is the Claimant last name - but as you can see it shows everything to the right of the first name. I tried ones from this thread too and they did not work: First name, Last Name Split in first column. Would you be able to help?