VBA code for count w and write into another column in excel

[tomlam]

Hi all

I face a problems that is i need to count how many w in column B and write into column C frequently in Excel .how to write VBA code to automatic
count and write total w as follow column c. Because i need to estimate the performance of thousand of students frequently

Column A column B column C


peter good;(2w2w)slow 4w
mary good
john not bad(1w1w1w1w) 4w
alxe good
tom bad(2w4w5w3w) 14w
simon good(1w2w3w) 6w

Thanks
Tom

[tomlam]

Column A column B column C
peter good;(2w2w)slow 4w
mary good
john not bad(1w1w1w1w) 4w
alxe good
tom bad(2w4w5w3w) 14w
simon good(1w2w3w) 6w

[Missinglinq]

Since this is an Excel question, it probably belongs in an Excel Forum:

http://www.msofficeforums.com/excel/

BTW, all VBA is not created equal! Even Functions with identical names perform differently, depending on the host app!

Linq ;0)>

[tomlam]

Thank you competent performer