Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get the middle name
how can i get the middle name of "fazain iqbal khan"... i can get the last
name by =(a2,len(a2)-search("#", substitute(a2&" "," ","#",2)))... and first name=right(a2,find(" ",a2)) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get the middle name
Roger Govier wrote...
Try =MID(A2,FIND(" ",A2)+1,FIND("#",SUBSTITUTE(A2, " ","#",2))-FIND("#",SUBSTITUTE(A2," ","#",1))-1) .... Satisfies the OP's specs, but how would it handle George Herbert Walker Bush? Or Malcolm X? For names like those, =MID(A2,FIND(" ",A2)+1,FIND("#",SUBSTITUTE(A2, " ","#",LEN(A2)-LEN(SUBSTITUTE(A2," ",""))))-FIND(" ",A2)) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get the middle name
Hi
Try =MID(A2,FIND(" ",A2)+1,FIND("#",SUBSTITUTE(A2," ","#",2))-FIND("#",SUBSTITUTE(A2," ","#",1))-1) Regards Roger Govier zomex wrote: how can i get the middle name of "fazain iqbal khan"... i can get the last name by =(a2,len(a2)-search("#", substitute(a2&" "," ","#",2)))... and first name=right(a2,find(" ",a2)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove middle initial from "first name middle initial" | Excel Discussion (Misc queries) | |||
First name, Middle Initial | Excel Discussion (Misc queries) | |||
Trying to freeze panes. line down and through middle of worksheet. | Excel Worksheet Functions | |||
Stripping Middle Initial from a Name | Excel Worksheet Functions | |||
Marcro recroding/ stop Ikon not appearing in middle of excel sheet | Excel Discussion (Misc queries) |