I am trying to find the location of all the blanks in a cell - the cell is woooord1 thru to word12 below | ||||||||||||||||
blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | blank | ||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | ||||||
characters | blanks | words | 9 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 34 | 34 | |||
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? | ||||||||||||||||
<colgroup><col><col span="2"><col><col><col><col><col span="10"></colgroup><tbody>
</tbody>