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