Try:

=LEN(F7)-LEN(SUBSTITUTE(LOWER(F7),"w",""))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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