Dividing name

[kd]

I have a long coloumn with names and I need to divide them into first name
and last name. Is there a formula for the same.

Any help would be appreciated.

Thanks,
KD

 

[Teethless mama]

Data > Text to Columns > Next > select Space > Next > Finish