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>

 

[oldbrewer]

charlie - row 2 is a counter for each sequential blank

 

[Charlie45]

I don't think you need that. that is what the B3+1 does

 

[oldbrewer]

https://app.box.com/s/5bno6jq2dxwwa1o8v032


is the link for my workbook

 

[Charlie45]

Just enter =FIND(" ", $A$3, B3 + 1) into Cell B3 and copy across. Try and see if it works.

Edit:
Sorry! Enter formula in C3 and copy across. It worked in the file you uploaded.

I got 3 as the position of the first blank, then 7 for the next and 11 for the next. Is that not what you wanted?

 

[oldbrewer]

charlie - the cell with the words and banks in it is A2

 

[Charlie45]

your file you uploaded had the words and blanks in A3. If you change then the formula changes and noone knows what you're doing. download the same file you upload and put =FIND(" ", $A$3, B3 + 1) in cell C3 and copy across. If that doesn't work then I am at a loss to help tou furtheer.

 

[oldbrewer]

the file i uploaded has words in cell A3, and I am trying to find the position of every blank. I tried your suggestion and got an error flag. A2 is where I am defining which blank to look for. But many thanks for joining in it is driving me wacky.

 

[Charlie45]

I'm sorry! I can't be of further help. It works for me.

 

[wwbwb]

Its working for me too.

*Note: There is a " " in position 1.

Excel 2010
	A	B	C	D	E	F	G
1
2			Blank 1	Blank 2	Blank 3	Blank 4	Blank 5
3	aa aaa aa aaa aa a aaa aaa		1	4	5	9	12
4			=FIND(" ", $A$3, B3+1 )	=FIND(" ", $A$3, C3+1 )	=FIND(" ", $A$3, D3+1 )	=FIND(" ", $A$3, E3+1 )	=FIND(" ", $A$3, F3+1 )
Sheet3

 

[oldbrewer]

wwbwb - the first blank is at 3 B3 is a blank cell - the 4th blank is at 14 in your set up