"Bernard Liengme" wrote in message
...
Try =LEN(A1)-LEN(SUBSTITUTE(A1,"w",""))

Bernard,

Doesn't fine upper case W

--
Regards,


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


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