Is the same question , but I want this formula you delete a name , even if the latter compound
This formula to separate the last name of the Full Name
Can you make it separating the Full Name without Last Name
=IF(OR(ISNUMBER(SEARCH({"Abd","Abou","Gab","Gad"},RIGHT($A2,LEN($A2)-3)))),TRIM(RIGHT(SUBSTITUTE($A2," ",REPT(" ",255)),255*2)),TRIM(RIGHT(SUBSTITUTE($A2," ",REPT(" ",255)),255)))
Bookmarks