Need formula for character limit based on Width of W

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?

Mindy,

You can set the cell limit by Data Validation, which will give you an error message if the text exceeds whatever character limit you set, but you then have to retype it omitting letters, as in your example

It can be done automatically if you can accept a "helper" column, because you set that to show the "trimmed" text that does fit your criteria.

Example:
Assume "Brown Dog" is in B1, and C1 sets the character limit.

Type into D1 "=LEFT(B1,C1)"

D1 will now show only the letters that fit your criteria.

If you want to set the values in Col C numerically, each Arial font, Size 10, capital letter 'W'.is 1.86 characters, so you can use that as a multiple.

If you can't use a "helper" column, it's all down to a simple Macro that measures and trims whatever you type into Col B

Hope this helps

Ochimus