This will either extract data before a space or the other code will extract anything after the first space.
For example, full name is in a cell and this needs to be split out.
Anything before the space
=LEFT(A5,FIND(” “,A5)-1)
Anything after the space
=RIGHT(A5,LEN(A5)-FIND(” “,A5,1))
Enjoy