Try this:

=LEFT(A1,FIND(" ",A1&" ")-1)

and

=RIGHT(A1,MAX(0,LEN(A1)-FIND(" ",A1&" "))) or =MID(A1,FIND(" ",A1&" "),100)