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