Help pls... Need to extract just last the text string from a cell

[Lester07]

Hi! I just have a simple question...

I have a list of names and I would like to extract the Lastname using a formula/function.
The problem is that when a full name on the list has two first names, my formula extracts the lastname but it includes the 2nd name that is on the firstname... (hope it make sense)

the formula i used is =MID(A2,FIND(" ",A2)+1,LEN(A2))

example for a name: "Mark Jay Robinson" - I just like to extract the last name "Robinson" but using my formula, it extract "Jay Robinson"

I couldn't find a way to count the text/character position from right to left (as in using the FIND function, it counts from left to right)

Thanks in advance....

 

[Domski]

Try: =TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",50)),50))

Assuming nobody has a surname longer than 50 characters.

Dom

 

[Lester07]

Hey it worked! Thanks!!!