Thanks alot Mr. Toppers.
Sridhar


"Toppers" wrote:

try:

=MID(A1,FIND("#",SUBSTITUTE(A1," ","#",(LEN(A1)-LEN(SUBSTITUTE(A1," ",
"")))),1),255)

"yshridhar" wrote:

Is there any function to pick out last name in the name of a person eg.
Lakshmi Narasimha kamal Kumar. I want to pick out the last name ie kumar in
the cell