Extracting Piece Of Text Having Specific Pattern From A Larger Text String

[snb]

Based on your examples:

=LEFT(MID(A1,FIND("0",A1)-1,100),FIND(" ",MID(A1,FIND("0",A1)-1,100)&" "))