Hi all,
my first post,
I cant post link to sheet so I have put up a picture with formula below

I need to modify my formula in B to give me the results I have listed in Colum C
=IFERROR(IFERROR(MID(A2,FIND("available for",A2)+14,10),MID(A2,FIND("Error: Material",A2)+16,15)),"")

my result varys in length so using +14,10 after search term is not working well as I'm either losing data or returning too much. can spaces be used ?

I hope this makes sense
Click image for larger version. 

Name:	Untitled.jpg 
Views:	14 
Size:	87.9 KB 
ID:	6269