Extracting two words from a string

err, it's a bit claggy but it works

=LEFT(LEFT(REPLACE(A1,1,FIND("for",A1)+3,""),FIND("#",REPLACE(A1,1,FIND("for",A1)+3,""),1)-2),FIND(" ",LEFT(REPLACE(A1,1,FIND("for",A1)+3,""),FIND("#",REPLACE(A1,1,FIND("for",A1)+3,""),1)-2),1)-1)&RIGHT(LEFT(REPLACE(A1,1,FIND("for",A1)+3,""),FIND("#",REPLACE(A1,1,FIND("for",A1)+3,""),1)-2),LEN(LEFT(REPLACE(A1,1,FIND("for",A1)+3,""),FIND("#",REPLACE(A1,1,FIND("for",A1)+3,""),1)-2))-FIND(" ",LEFT(REPLACE(A1,1,FIND("for",A1)+3,""),FIND("#",REPLACE(A1,1,FIND("for",A1)+3,""),1)-2),1))