Maybe

=MID(E4,FIND(" ",E4,FIND(" ",E4)+1)+1,LEN(E4))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"zomex" wrote in message
...
thanks for the wonderful reply.... i couldnt get the middle name though
the
formula that i was using sure did get me the last name and the3 formula is
=MID(E4,FIND(" ",E4,FIND(" ",E4)+1),LEN(E4)) ...the other formula
did
work, but it shows the result like "0UsMan" and for even it shows
"1UmEr"...how can i remove this "0" abd "1"... :)

"JulieD" wrote:

Hi Zomex

your teacher is obviously in a mean mood today :)

for this one - one answer involves a combination of MID and SEARCH
functions

the way to approach it is
- locate the first space using the SEARCH function
- locate the second space using the SEARCH function (you'll have to nest
the
first formula in here again to get your starting point), then subtract
the
first formula again to calculate the number of chatacters between the
two
spaces.

then nest these two formulas in the MID function.

Using the above method will give you leading and trailing spaces, these
can
easily be edited out by modifying the formula (once you get that far).

Give it a go and if you'ld like more help, just post back.

Cheers
JulieD

julied at hctsReMoVeThIs dot net dot au


"zomex" wrote:

eg. "mick jagger bush" "muhammad ali clay" "ayesha bin batool"
suppose that these r the names and i want formula that would be
generic to
all, such that it gets "jagger" "ali" and "bin"