Return remainder start/remainder of text string before/after a specific character

I am trying to compare a list of names between two sheets. Unfortunately the names are not formatted the same. One sheet has a first name column and a last name column. The second sheet has a full name that includes a middle initial and/or one or more middle names. I am trying to come up with a formula that would return the start of a text string until it hits the space and then another that would return the remainder after hitting the last space. Text to columns doesn't work too well since it is a different number of names for different people. Here is an example of what I have and what I would like it to return. Any help would be appreciated.

Sample data: John James William Doe
Formula 1 result: John
Formula 2 result: Doe

I figured out formula one (=LEFT($C2,SEARCH(" ",$C2,1))), but I am struggling with formula 2

Nevermind... I figured out how to do this. Let me know if anyone needs the solutionand I can send it to them. I had to do it in several steps in several columns in order to wrap my brain around it so I know it won't make sense if I try to explain it here.