ExcelBanter - Last name in a Name

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Last name in a Name (https://www.excelbanter.com/excel-discussion-misc-queries/149733-last-name-name.html)

yshridhar

Last name in a Name

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

Last name in a Name

=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)

"yshridhar" wrote in message
...
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

Toppers

Last name in a Name

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

yshridhar

Last name in a Name

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

All times are GMT +1. The time now is 03:06 PM.