I have a spread sheet that has locations in it formated as : 1A2, 1B2,
1C2,

1A3, 1B3, 1C3 , on and on etc....

I need to sort it so all the 1A2's are listed, then the 1B2's then the 1C2's
, and then the 1A3's , 1B3's , etc




How can I achieve this ....
If I remove all the first digits and then sort It gets it close too what I
need, but I still have to do a lot of cutting and pasting to get the final
product.... Also removeing all the first digits is a huge task.....


I know there has to be an easier way.... but I don't have as much experiece
and knowledge..


Any suggestions would be appreciated...
Thanks
Grace