Get First Name

=LEFT(A1,SEARCH(" ",A1)-1)

People in some countries only use one name, so if there is just one name present (no spaces) this formula will prevent errors.

=IF(ISERROR(SEARCH(" ",A1)-1),A1,LEFT(A1,SEARCH(" ",A1)-1))