Basic take-away is:
=LEFT(A1,FIND(” “,A1,1)-1)
=RIGHT(A1,LEN(A1)-FIND(” “,A1,1)
Here is a really good article on it.