tintin1012000
Board Regular
- Joined
- Apr 27, 2011
- Messages
- 237
im using below formula
when I find the text ''available for'' i want to return the next word, ie what ever is after the next space and before the space after that, i need this as the result can vary in length and my formula is limiting me
eg
cell B2 contains, available for sunday and Monday then result would be ''sunday''
or it could contain available for 987 today then result would be ''987''
HTML:
=IFERROR(IFERROR(MID(B2;FIND("*available for*";B2)+14;10);MID(B2;FIND("*Error: Material*";B2)+16;10));"")
when I find the text ''available for'' i want to return the next word, ie what ever is after the next space and before the space after that, i need this as the result can vary in length and my formula is limiting me
eg
cell B2 contains, available for sunday and Monday then result would be ''sunday''
or it could contain available for 987 today then result would be ''987''