I have data in several rows and columns ie:

95500 10
95501 10
R3550 40
S123 60
49996Y 40

I want to have this data sorted in a specific order, but not the way EXCEL
would like to sort it. My mainframe sorts by numbers first, then by letters
second, then by numbers mixed with letters third.

I can obtain a "Master sort list" to go by when I want to start, but how do
you force EXCEL to use this list (rather long list by the way)