Hammen, Jr., Ed

Facend Jr., Terry

Flynn, Mel

Van Fleet, Jean

Crowe, Don

I am using the following formula to get the first name:

=IF(ISERROR(RIGHT(R2,LEN(R2)-FIND(" ",R2,1))),"",RIGHT(R2,LEN(R2)-FIND(" ",R2,1)))

And the following formula to get the last name:

=IF(ISERROR(LEFT(R2,(FIND(" ",R2,1)-2))),"",LEFT(R2,(FIND(" ",R2,1)-2)))

How can I adjust my formulas to account for the two surnames in different formulas and the two word last names? These formulas work fine for single word first names and single word last names. I want to put the last name followed by surname in one cell and the first name in another.

Thank you in advance for your help.