G Guest May 11, 2006 #1 How do I count the number of letters in a string? For example, the number "W" in this string "WWWEEERRRWWDDR" is 5.
How do I count the number of letters in a string? For example, the number "W" in this string "WWWEEERRRWWDDR" is 5.
P Peo Sjoblom May 11, 2006 #2 =LEN(A1)-LEN(SUBSTITUTE(A1,"W","")) with the string in A1 -- Regards, Peo Sjoblom http://nwexcelsolutions.com
=LEN(A1)-LEN(SUBSTITUTE(A1,"W","")) with the string in A1 -- Regards, Peo Sjoblom http://nwexcelsolutions.com
B Bob Phillips May 11, 2006 #3 =LEN(A1)-LEN(SUBSTITUTE(A1,"W","")) -- HTH Bob Phillips (remove xxx from email address if mailing direct)
=LEN(A1)-LEN(SUBSTITUTE(A1,"W","")) -- HTH Bob Phillips (remove xxx from email address if mailing direct)
G Guest May 11, 2006 #4 Try this: With A1 containing WWWEEERRRWWDDR B1: =LEN(A1)-LEN(SUBSTITUTE(A1,"W","")) Does that help? *********** Regards, Ron XL2002, WinXP
Try this: With A1 containing WWWEEERRRWWDDR B1: =LEN(A1)-LEN(SUBSTITUTE(A1,"W","")) Does that help? *********** Regards, Ron XL2002, WinXP
