complex sorting formula or macro needed

Hi. I need some formula or macros that will sort in a complex way, the result should be sorted first alphabetic order than in numeric order, if it contains dash “-“after dashes in numeric order. Presently I am doing it manually and using great time using excel sort function 2003 but as you guess excel sorting is not the way I want, Many thanks to whoever shares this defy.

A possible commercial solution... http://www.contextures.com/excel-sort-addin.html (Special Sort Excel add-in) -- Jim Cone Portland, Oregon USA

"Geo" geocan2006@yahoo.ca

Hi. I need some formula or macros that will sort in a complex way, the result should be sorted first alphabetic order than in numeric order, if it contains dash “-“after dashes in numeric order. Presently I am doing it manually and using great time using excel sort function 2003 but as you guess excel sorting is not the way I want, Many thanks to whoever shares this defy.