=LEN(A1)-LEN(SUBSTITUTE(A1," ",""))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John" wrote in message
...
Is is possible to determine the number of blank characters entered in a
cell? What I mean by Blank, is when the user uses the spacebar to clear
the
contents of the cell

I have used =LEN but that returns a value for all characters blank and
otherwise.


Thanks