Splitting names

[mehmetics]

How can I split a name into First(&middle if he/she has) and last name.
I don't want each of first, middle and last names separately.

Results should be as in the sample file.

[Bo_Ry]

Please try at
B2
=SUBSTITUTE(A2," "&C2,)
C2
=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",50)),50))

[mehmetics]

Thank you very much