I have a large document with a couple of hundred names, I want to put the names in alphabetical order by surname, unfortunately, the names have been entered with the first name in front, IE John Jobinson etc.
I put in a new column with the following formula
which worked OK except where there is also a middle name, it then copies across the middle and last name.
Can anyone suggest a formula to copy across the surname only?
No, can't delete the middle name as this (apart from the employee number) is the only way to easily differentiate people with the same first and second name.