|I am trying to find the location of all the blanks in a cell - the cell is woooord1 thru to word12 below|
|woooord1 worddd2 wwwwwwwwwwwword3 word4 word5 word6 word7 word8 word9 word10 word11 word12||90||11||12|
|formula in first results cell which correctly gives 9 is =FIND(" ",$D$8,FIND(" ",$D$8)+I6-1)|
|this cell is I7 and has been copied across|
|the sentence is in D8|
|the second blank is correctly found|
|third and subsequent blanks are not found|
|can anybody tell me why please?|
This question generated 35 answers. To proceed to the answers, click here.
This thread is current as of November 21, 2013.