How to count occurances of a specific character in a range?

Hello everyone,
Thanks for all the great help on these forum, I've been reading lots and learning from all the great responses. This one seems to elude me.

I have named a set range equal to cell B8. I want to change the range if cell b8 contains only one hyphen and keep that range if it has 2 and warn if it has more than 2 hyphens.

so B8 looks usually like " 10-123-01" or "10-123"
Here is what the pseudo code looks like:

Please Login or Register  to view this content.

Hi

Broadly you could do something like

Please Login or Register  to view this content.

This will allow you to set it if it is 1, do nothing if it is 2 or give a warning if it is > 2. You may also want to cover the situation where you have no hyphens in the result.

HTH

rylo

Thanks for wakening me up shg

I didn't read the question again!!!

Rather than further clutter the BB I have edited Post #3