Re: Is it Possible

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

--

HTH

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


"John" <r.@xxxxxxxxxxxxxxx> wrote in message
news:dpc3j5$48l$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> 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
>
>


.

Relevant Pages

  • Re: very hard deleting rows issue
    ... Your sentiments are well meant: ... >>> HTH ... >>> (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: Input from TextBox on UserForm
    ... "Kev" wrote in message ... When I go back and look at the range cell> references, they do not include the complete customer> list. ... >>(remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.misc)
  • Re: I want to be able to count the number of checked boxes in a fo
    ... >> Link each checkbox to a cell, ... >> HTH ... >> (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.worksheet.functions)
  • Re: summing comma separated values in a range
    ... > HTH ... > (remove nothere from the email address if mailing direct) ... >> number of csv to the number in the formula. ...
    (microsoft.public.excel.programming)
  • Re: SUMIF where values to be summed are formula
    ... >> HTH ... >> (remove nothere from the email address if mailing direct) ... >>> criteria to be considered in deciding which values are to be added. ...
    (microsoft.public.excel.worksheet.functions)