Excel: finding each blank in a cell


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?


This question generated 35 answers. To proceed to the answers, click here.

This thread is current as of November 21, 2013.


For more resources for Microsoft Excel