tintin1012000
New member
- Joined
- Jan 16, 2017
- Messages
- 3
- Reaction score
- 0
- Points
- 0
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
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