I would like excel to sort data reading from right to left i.e 61 43 75 57 29 Is this possible?
D dbrowne Sep 7, 2003 #1 I would like excel to sort data reading from right to left i.e 61 43 75 57 29 Is this possible?
J JohnI in Brisbane Sep 7, 2003 #2 dbrowne, It's possible. Please give more information about your data. Is it always two digits, or can there be 0, 1, 3, or more digits? If only two it's a simple matter of using a helper column with the formula - =RIGHT(A2,1)&LEFT(A2,1) and sort using that column. regards, JohnI
dbrowne, It's possible. Please give more information about your data. Is it always two digits, or can there be 0, 1, 3, or more digits? If only two it's a simple matter of using a helper column with the formula - =RIGHT(A2,1)&LEFT(A2,1) and sort using that column. regards, JohnI
