Count within cell

[texasalynn]

I need to be able to count within a cell.

For example I have -M---FS and want to return 3.

The column has for each day the appropriate letter where a customer has service. Any ideas?

[Aladin Akyurek]

On 2002-05-20 12:55, texasalynn wrote:
I need to be able to count within a cell.

For example I have -M---FS and want to return 3.

The column has for each day the appropriate letter where a customer has service. Any ideas?

If you really have hyphens in such words, use:

=LEN(SUBSTITUTE(A1,"-",""))

where A1 houses a value like -M---FS.

[Ricky Morris]

Try the following custom funtion:

Function charcount(Arg As String) As Integer
For x = 1 To Len(Arg)
If LCase$(Mid(Arg, x, 1)) > "a" And LCase$(Mid(Arg, x, 1)) < "z" Then
charcount = charcount + 1
End If
Next
End Function


In your sheet type:
=charcount(A1)