character count

[Guest]

I seem to have misplaced a function.


What is hte method for counting how many times a specific character occurs
inside a string without looping through it?
eg...

a = FUCNTIONCHARSEARCH("The quick brown fox ran over the yard.","t")
a = 2


?

 

[Chip Pearson]

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

or in VBA

Dim L As Long
Dim S As String
S = "abcda"
L = Len(S) - Len(Replace(S, "a", ""))
Debug.Print L


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"ben" <&&&&[email protected](remove this if mailing direct)>
wrote in message
news:[email protected]...

 

[Guest]

ah, brilliant

thank you