I am needing to sort the list below numerically first and then alphabetically ignoring everything before the number. The problem I have run into with all functions is there is no consistency in the length of the number or the text following it. Any help would be GREATLY appreciated.


PNW 027.625 Nor
PNW 133.1 Mun v. 2
PNW 248 Smi
PNW 266 Dry
PNW 289.6 Bee
PNW 305.22 Swe
PNW 305.244 Herric
077.3 Pre
178.3 Sul
179.3 Wiehl
180.7 Armstr
182.7 Chapma
200.7 Tenzer
270 Alv
279.1 Holtha
279.20973 Edelma
O 077.3 Pre
O 178.3 Sul
O 179.3 Wiehl
O 180.7 Armstr
O 182.7 Chapma
O 200.7 Tenzer
O 270 Alv