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

Judith Campf

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!

Judy

Ray Lindstrom

Hi @Judith Campf,

Try this:

=RIGHT([Full Name]@row, LEN([Full Name]@row) - FIND(CHAR(10), SUBSTITUTE([Full Name]@row, " ", CHAR(10), LEN([Full Name]@row) - LEN(SUBSTITUTE([Full Name]@row, "-", "")))))

Ray Lindstrom

Hi @Judith Campf,

Try this:

=RIGHT([Full Name]@row, LEN([Full Name]@row) - FIND(CHAR(10), SUBSTITUTE([Full Name]@row, " ", CHAR(10), LEN([Full Name]@row) - LEN(SUBSTITUTE([Full Name]@row, "-", "")))))

Judith Campf

That did it! My sincerest thanks.

Judy