Try:

=MID(A1,SEARCH(B1,A1),SEARCH(" ",MID(A1&" ",SEARCH(B1,A1),255)))

Where A1 contains original string and B1 contains string to search for.