View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gino986 gino986 is offline
external usenet poster
 
Posts: 1
Default Sort by last two characters, not the first.

I have a simple database; multiple rows and columns. I need to sort all the
data by info in one of the columns. I need to sort by the LAST TWO characters
of records in that column. Example of records:

R-BOILER-DA
R-FANCOILUNIT-QT
U-TRANSPAD-AN

All the data in the rows needs to stay together.