I'm trying to sort a large column of 6 digit characters by the last character in each field.
J jmdyt Apr 24, 2007 #1 I'm trying to sort a large column of 6 digit characters by the last character in each field.
D Dave Peterson Apr 24, 2007 #2 Add a column to the right of that column. Use a formula like: =right(a1,1) to get that last digit. Then sort your range by this column. When you're done, delete this column.
Add a column to the right of that column. Use a formula like: =right(a1,1) to get that last digit. Then sort your range by this column. When you're done, delete this column.
