SORTING PROBLEM

[Grace]

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

 

[Jim Cone]

Grace,
Assuming your data is in a single column and it starts in B5.
Using two adjacent blank columns...
This formula in the first extra column: =RIGHT(B5,LEN(B5)-1)
This formula in the other extra column: =RIGHT(B5,1)
Sort all three columns using the first extra column, the "other"
column and then your original data as the sort column order.
Depending on the full extent of your data, it may do what you want.
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html


"Grace" <[email protected]>
wrote in message
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

 

[Grace]

Thank you ... it has gotten me closer... not completey where I need it
yet... but I will keep fooling with it..

Thanks