RE: count digits within cell

Tech-Archive recommends: Speed Up your PC by fixing your registry



Thanks!

"Gary's Student" wrote:

> Try:
> =len(a1)
>
> "apostate2" wrote:
>
> > I want to create a forumula in B1 that will sum up how many letters I have
> > entered into A1. There will never be more than five digits in A1. I frankly
> > don't know where to begin.
> >
> > example: A1 = MTW
> > --
> > Thanks for being here
.



Relevant Pages

  • RE: count digits within cell
    ... "apostate2" wrote: ... > I want to create a forumula in B1 that will sum up how many letters I have ...
    (microsoft.public.excel.misc)
  • Pentagraphic cipher
    ... Playfair, with each axis numbered 0 - 4, for example: ... Divide the plaintext into groups of five letters ... Add the sum of the X coordinates to each Y coordinate and the ... that duplicate letters in the original do not encode to the same letter ...
    (sci.crypt)
  • Re: Top Values for Each Student
    ... I need a query to return the Sum of the TOP 15 values for each ... Each student could have any number of scores. ...
    (comp.databases.ms-access)
  • RE: summing according to groups
    ... Gary's Student ... I tried messing with the pivot table, but I couldn't find how to do it... ... drag type into the row area and number into the data ... number from each type and sum all the those numbers together. ...
    (microsoft.public.excel.misc)
  • RE: VBA Cell Selection via input box
    ... The sum pops up at the bottom only after the ... selection is complete. ... Gary''s Student - gsnu200771 ... "JTech" wrote: ...
    (microsoft.public.excel.programming)