Thread: count number of letters in a string
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default count number of letters in a string
=LEN(A1)-LEN(SUBSTITUTE(A1,"W",""))

with the string in A1

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"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.


Reply With QuoteReply With Quote