sorting contents from right to left

G

Guest

Do you know of a way to sort contents of a column from right to left? They
are formatted as text fields, even though their contents are numbers but they
are not consistent lengths of numbers. Someone said I should change the
language to Arabic or something?
12345
347
5443
7654
12
3452
 
V

vezerid

It would have helped, you know, if you had also shown how you would
expect them to be sorted. I assume that you want 12345 to be sorted as
if it was 54321? If so, use the following formula next to your data
(assuming start from A2).

=SUMPRODUCT(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),
1)*10^(ROW(INDIRECT("1:"&LEN(A2)))-1))

Sort by this column.

HTH
Kostis Vezerides
 

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

Sorting Right to Left 1
Left and Right Function 4
How can I combine two formulas Left/Mid/Right + Substitute? 7
Sorting rows left to right numerically 1
Excel Macro to automatically go to the right of the last colored cell 0
Left-Right Functions? 1
Combining Cell Contents - entire columns 7
FIND from right to left instead of left to right 8

Top