Re: Is it Possible

Thanks Bob, very very clever


"Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:uqUkL59DGHA.3904@xxxxxxxxxxxxxxxxxxxxxxx
> =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)