Hi Eric,
Take the length of the original and subtract the length with the "W"
removed.,
add same for the lowercase, since SUBSTITUTE is case-sensitive.
=(LEN(A1)-LEN(SUBSTITUTE(A1,"W",""))) +
(LEN(A1)-LEN(SUBSTITUTE(A1,"w","")))
or
=LEN(A1)-LEN(SUBSTITUE(UPPER(A1),"W"))
More of the same type of things on my strings page
http://www.mvps.org/dmcritchie/excel/strings.htm
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
"Eric" wrote in message
...
Does anyone have any suggestions on how to count the char "w" within cell
A1?
For example, in cell A1, waterfall - wc, please ignore the upper / lower
case, I would like to count how many "w" or "W" inside the cell A1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric