Great Solution SAM
On Mon, Sep 5, 2011 at 10:48 PM, GoldenLance wrote:
> =SUMPRODUCT(LEN(A1)-
> LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW(INDIRECT("65:90"))),"")))
>
> from
> http://www.excelfox.com/forum/showthread.php?135-Count-Alpha-In-AlphaNumeric-Text
>
> GL
>
> On Sep 5, 9:09 pm, Intelligent But C
=SUMPRODUCT(LEN(A1)-
LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW(INDIRECT("65:90"))),"")))
from
http://www.excelfox.com/forum/showthread.php?135-Count-Alpha-In-AlphaNumeric-Text
GL
On Sep 5, 9:09 pm, Intelligent But Crazy wrote:
> Thanks Noorain,
>
> for your Quick Help. but actually my requirement is F
Thanks Noorain,
for your Quick Help. but actually my requirement is Formula, is there any
inbuilt formula or combination of inbulilt formulas??
On Mon, Sep 5, 2011 at 9:09 PM, Intelligent But Crazy
wrote:
>
> Dear Group,
>
> Is there any formula which can give the count of alphabets in a cell
Dear Pankaj,
Please try itand see attached sheet..
*Function Count_text(s As Range)
For i = 1 To Len(s)
If VBA.Asc(Mid(s, i, 1)) > 65 And VBA.Asc(Mid(s, i, 1)) < 90 Or
VBA.Asc(Mid(s, i, 1)) > 96 And VBA.Asc(Mid(s, i, 1)) < 123 Then
Count_text = Count_text & VBA.Mid(s, i, 1)
End If
Nex