Most valuable professional
  • Hot Topics

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 woooord1 worddd2 wwwwwwwwwwwword3 word4 word5 word6 word7 word8 word9 word10 word11 word12 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:

This article includes the following tags:

  • Excel
  • Microsoft Excel