Rank strings and values

[BRISBANEBOB]

Using formula, how do I rank

CAM100-24
COM98-21
CAM100-18
CAM27-37
COM121-5
COM98-23

so it first sorts in alphabetical order using the string before the "-" i.e. CAM27 comes before CAM100, and then by the biggest 'secondary values' (the value after the "-") so that COM98-23 comes before COM98-21?

[BRISBANEBOB]

Solved - use two helper columns

[ranganathanvr]

I can able to vivew =char (171) star
how to make star ranking in xl