Thanks Ron - yours worked dynamically, whereas Mike's would be fine for data
that is the same number of characters everytime.

"Ron Rosenfeld" wrote:

=MID(A1,FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),3))+1,
FIND(" ",A1,FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),3))+1)-
FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),3))-1)


--ron