Last name in a Name

[Guest]

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

 

[Bob Phillips]

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

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

try:

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

 

[Guest]

Thanks alot Mr. Toppers.
Sridhar

try:

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