finding each blank in a cell

[oldbrewer]

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>

 

[wwbwb]

No. " "aa" "" "aaa" "aa" "aaa" "aa" "a" "aaa" "aaa
they are 1,4,5,9,12,16,19,21,25

Yes, B3 is supposed to be blank.

 

[oldbrewer]

sorry - assumed single blank between words

 

[oldbrewer]

now agree your formula works perfectly - but - I cannot see the logic of it - you are using the position of the previous blank to generate the position of the next blank - is it looking for the first blank AFTER a specific character number?

 

[wwbwb]

Right, you are using the position of the previous because the the find formula uses a start number. The first time you use the formula, it is looking for the " " in 0+1= 1, on or after position 1 . The second time it would be 1+1=2, on or after position 2. The third time it would be 4+1=5, on or after postion 5.

Before when you had the formula looking at your header to pull the number and getting the 3,3,3,7,7,7,... it was doing 0+1=1 on or after position 1, 1+1=2 on or after position 2, 2+1=3 on or after position 3, 3+1=4 on or after position 4.

Hope that helps.

 

[oldbrewer]

It does - thank you very much.