This is one of my Magical hacks. I store Spreadsheet formulas to make my life easy. I can't remember how to split the first name from the last name of a full name of people, so I saved =LEFT(A2,FIND(" ",A2,1)-1) to split the first word (which is usually first name of a full name) from the rest of the name.

Check it out!