Thread
:
how to get the middle name
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
zomex
Posts: n/a
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))
Reply With Quote
how to get the middle name