Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is there a way to count the number of capitalized characters in a text cell?
    For example, a cell value of "TTest" would return a result of 2.

    TIA
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    For cell A1:

    =SUMPRODUCT((CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1) )),1))>64)*(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1)) ),1))<91))

    This only counts letters A...Z, not letters with accents such as .

  3. #3
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='764877' date='12-Mar-2009 01:19']For cell A1:

    =SUMPRODUCT((CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1) )),1))>64)*(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1)) ),1))<91))

    This only counts letters A...Z, not letters with accents such as .[/quote]


    Hans

    Thanks.
    I am always lost when it come to text and together with mega-formula
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •