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.
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.