| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
