View Single Post
  #1   Report Post  
mbparks
 
Posts: n/a
Default Sort by last 2 digits

I would like to sort a column by the last 2 digits of the cell entry. The
entries will begin with 2 to 3 letters followed by 7 numeric digits. Example:
BY0123456.
I would like to sort using the 56. How can I accomplish this?