¥¿«hªí¹F¦¡
µ¹°Ñ¦Ò :
°ÝÃD : ¨D¤@¦r²Å¦ê¦r¥ÀÓ¼Æ
A1= ascd2G34dH_º~¦r!ya¡A¤£°Ï¤À¤j¤p¼g¡Cµª®×¬O9
1] ¨ç¼Æ¸Ñªk :
=SUMPRODUCT(--(ABS(CODE(MID(UPPER(A1),ROW(INDIRECT("1:"&LEN(A1))),1))-77.5)<13))
2] ¥Î"¥¿«hªí¹F¦¡" (Regular Expression), ¼gªº¦Ûq¨ç¼Æ :
Function CountAlpha(Mystr)
Dim RegExp As Object
Set RegExp = CreateObject("vbscript.regexp")
RegExp.Global = True
RegExp.ignorecase = True
RegExp.Pattern = "[^a-zA-Z]"
CountAlpha = Len(RegExp.Replace(Mystr.Value, ""))
End Function |