Excel: Splitting Names

I've been working on a project that requires the manipulation of name data. A lot of the names were given as full names, some with multiple last names, that for the purposes of data manipulation had to be split. Here's the simple way to do it:

Assuming data is in A1 and the value of the cell is "Charles Kingsford Smith"

For First Name use:

=LEFT(A1,FIND(" ",A:A)-1)

for a resulting value of "Charles"

and for Last Name use:

=MID(A1,FIND(" ",A1)+1,LEN(A1))

for a resulting value of "Kingsford Smith"