Gary''s Student wrote:
With your data in column A, in B1 enter:

=MID(A1,SEARCH(" ",A1&" ",SEARCH(" ",A1&" ",1)+1)+1,SEARCH(" ",A1 & "
",SEARCH(" ",A1&" ",SEARCH(" ",A1&" ",1)+1)+1)-SEARCH(" ",A1&" ",SEARCH("
",A1&" ",1)+1)-1)

and copy down.

Hi Gary, thank you for the formula. I just encountered some problem with it.
A message prompted "You entered too many arguments for this function.

I need your help...

[quoted text clipped - 22 lines]

Thank you!

--
Message posted via http://www.officekb.com