BREAK FULL NAME TO FIRST & LAST IN EXCEL

=TRIM(LEFT(A1,FIND(” “,A1))) – The FIND function will return the numeric value for the space in the name (in the example, the value is 5) then the LEFT function will get the leftmost NAME