Use COUNTIF() to find the number of cells not equal to a blank space

Originally Posted by zbor

So what are you trying to do? Count cells with one space?

use =COUNTIF(A1:A1000," ")

Sorry, actually count cells without one space Most of the cells have proper strings, but some cells only have one spaces " "