I'm trying to amend this formula to find the last name in a cell that has the a fist name and second name, as copied from cpearson, a big thank you too him :
=TRIM(RIGHT(K239,LEN(K239)-IF(ISERROR(FIND(" ",K239,FIND(" ",K239,FIND(" ",K239,1)+2))),LEN(K239),FIND(" ",K239,FIND(" ",K239,FIND(" ",K239,1)+2))-1)))
I have already amended it to look for spaces rather than "," seperators. But it will only work when there is a middle name. Is it possible to change it to find the last name only?
Any help would be much appreciated.
=TRIM(RIGHT(K239,LEN(K239)-IF(ISERROR(FIND(" ",K239,FIND(" ",K239,FIND(" ",K239,1)+2))),LEN(K239),FIND(" ",K239,FIND(" ",K239,FIND(" ",K239,1)+2))-1)))
I have already amended it to look for spaces rather than "," seperators. But it will only work when there is a middle name. Is it possible to change it to find the last name only?
Any help would be much appreciated.