Extract First Name and the remaining Name

Dear Experts,

Could you please help on my below requirement.

I need to extract the name from the Full name to two columns saying "First Name" and "Last Name"

I have given the example below,

AARON CRIS RICK MORALES VILLANUEVA - AARON (First Name) CRIS RICK MORALES VILLANUEVA (Last Name)


Apart from the First name the balance should come as Last name

hi there. if full name in A1, try this in B1:
=LEFT(A1,FIND(" ",A1)-1)

and in C1:
=MID(A1,FIND(" ",A1)+1,LEN(A1))
or:
=SUBSTITUTE(A1,B1&" ","",1)

Thanks for your help. Really Appreciate.Thread is solved.