I have text in one column (Column B) that cannot exceed a certain limit (numeric value in Column C). This limit varies, depending on the row. The character limit is based on Arial font, Size 10, capital letter 'W'.

Example: "Brown Dog" cannot exceed the length of 5 W's. Until I find some kind of formula, I have to manually check:
Brown Dog
WWWWW

This text is too long. I need to remove 1 character, so it says 'Brown Do'.

"Pickle" cannot exceed the length of 3 W's.
Pickle
WWW
This is acceptable.

I'm using PC Excel 2010.

Suggestions please?