count number of letters in a string
=LEN(A1)-LEN(SUBSTITUTE(A1,"W",""))
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"Wiley" wrote in message
...
How do I count the number of letters in a string? For example, the number
"W" in this string "WWWEEERRRWWDDR" is 5.
|