sorting contents from right to left

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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 rows left to right numerically 1
Left and Right Function 4
how do cells run left to right 1
Sum Left Side & Right Side Numbers 4
What's happened to the Sort in 2007? 1
LEFT / RIGHT functions 3
How can I combine two formulas Left/Mid/Right + Substitute? 7
Sorting Right to Left 1

Back
Top