writing sirname in different cell

[Naresh Maloo]

I have a students name list in excel sheet. I want only sirname of all student in next corresponding cell.For example name is naresh kumar maloo. And sirname will be maloo. what will be the formula.thaking in advance.

 

[VoG]

Try

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255))

 

[azumi]

=right(a1,len(a1)-find(" ",a1,find(" ",a1,1)+1))

 

[Naresh Maloo]

thanking you your answer is correct . I am grateful for you.