Sort by reading data right-to-left.

D

dbrowne

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT where between 2 dates 3
Creating a Chart on form from selected data in query. 0
Formula Error When Sorting 1
calculating average handling time 7
Cannot sort a table containing text 5
How do I combine 2 data sets using date? 2
VBA Coding Help for Beginner 0
Value of the first day of a year in a list 5

Top