Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I extract the last name in Excel, from a list of names lik.
Trying to extract last name from a cell (db field) which contains names like:
John Doe John B. Doe J.B. Doe Various combinations of formulas such as =Right(C17,Len(c17)-FIND(" ", C17)) Can't find the right combination to do the job. Thanks |
#2
|
|||
|
|||
Hi
try: =MID(A1,LOOKUP(2,1/(MID(A1,seq,1)=" "),seq)+1,1024) where seq is a defined name ('Insert- Name - Define') with the formula seq: =ROW(INDIRECT("1:1024")) "RobertC" wrote: Trying to extract last name from a cell (db field) which contains names like: John Doe John B. Doe J.B. Doe Various combinations of formulas such as =Right(C17,Len(c17)-FIND(" ", C17)) Can't find the right combination to do the job. Thanks |
#3
|
|||
|
|||
Frank:
Thank you for posting a solution. The solution did not work. I must be misunderstanding the use of seq and 1024. Thank you. Robert "Frank Kabel" wrote: Hi try: =MID(A1,LOOKUP(2,1/(MID(A1,seq,1)=" "),seq)+1,1024) where seq is a defined name ('Insert- Name - Define') with the formula seq: =ROW(INDIRECT("1:1024")) "RobertC" wrote: Trying to extract last name from a cell (db field) which contains names like: John Doe John B. Doe J.B. Doe Various combinations of formulas such as =Right(C17,Len(c17)-FIND(" ", C17)) Can't find the right combination to do the job. Thanks |
#4
|
|||
|
|||
you can do text to column with <space as delimiter but the last name may
not be in the same column RobertC wrote in message ... Trying to extract last name from a cell (db field) which contains names like: John Doe John B. Doe J.B. Doe Various combinations of formulas such as =Right(C17,Len(c17)-FIND(" ", C17)) Can't find the right combination to do the job. Thanks |
#5
|
|||
|
|||
Hi
then try: =MID(A1,LOOKUP(2,1/(MID(A1,ROW(INDIRECT("1:1024")),1)=" "),ROW(INDIRECT("1:1024")))+1,1024) "rccline" wrote: Frank: Thank you for posting a solution. The solution did not work. I must be misunderstanding the use of seq and 1024. Thank you. Robert "Frank Kabel" wrote: Hi try: =MID(A1,LOOKUP(2,1/(MID(A1,seq,1)=" "),seq)+1,1024) where seq is a defined name ('Insert- Name - Define') with the formula seq: =ROW(INDIRECT("1:1024")) "RobertC" wrote: Trying to extract last name from a cell (db field) which contains names like: John Doe John B. Doe J.B. Doe Various combinations of formulas such as =Right(C17,Len(c17)-FIND(" ", C17)) Can't find the right combination to do the job. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Address List in Excel | Excel Discussion (Misc queries) | |||
export excel file to outlook express contact list | New Users to Excel | |||
How do I put a list of names and e-mail addresses in excel so tha. | Excel Discussion (Misc queries) | |||
How do I import a Windows Explorer list into Excel? | Excel Discussion (Misc queries) |