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!