How do I split first name last name into two cells?


I have one cell with first name last name (e.g. Judy Campf). I want to pull out "first name" and "last name" into their own columns.

This formula worked for the first name.

=LEFT([Active Teachers]@row, FIND(" ", [Active Teachers]@row) - 1)

I can't get a similar formula to work for the last name.

Thanks in advance!


Best Answer