Moving the last name into a different column

[dankar]

I need help with the following, I have a list of 200+ name and I want to cut the last name and paste in the first column like the image.

I have 3 cases in all the names :
1. first name, middle name and last name ( I just want to remove the last name and paste it under last name column like first example in image)
2. First name and last name ( just want to remove the last name and paste it under last name column like second example in image )
3. Only first name. (just keep it as is)

Thanks.

 

[JEC]

Well try it in a new empth workbook with some names in column L. Then run it.