count number of letters in a string
Try this:
With A1 containing WWWEEERRRWWDDR
B1: =LEN(A1)-LEN(SUBSTITUTE(A1,"W",""))
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Wiley" wrote:
How do I count the number of letters in a string? For example, the number
"W" in this string "WWWEEERRRWWDDR" is 5.
|