Sorting from Right to Left

[mcpete89]

Question--how do you sort an excel column from the right to the left of the cells. For instance I want to sort all the items ending in zzzz, and I want to sort all the cells from right to left (either in an ascending or descending order)

aabeasmuno
aafitzgeraldzzzz
aanya
aaronaonblackman
aarondickinson@zzzz

[Richard Buttrey]

Hi, I don't understand. Can you clarify please? What do you mean by sorting 'right to left of the cells'?

Rgds

[mcpete89]

Instead of the normal sort of a column where it would start with the first letter of the cell, I want to start with the last letter of the cell and sort BACK from there


NORMAL ASCENDING SORT
aabeasmuno
aafitzgeraldzzzz
aanya
aaronaonblackman
aarondickinsonzzzz



SORT FROM LAST LETTER OF THE CELL [LAST LETTER OF THE FIRST WORD IS “A”, SECOND WORDS LAT LETTER IS “N”}
aanya
aaronaonblackman
aabeasmuno
aafitzgeraldzzzz
aarondickinsonzzzz

Does that help?

[Richard Buttrey]

Hi,

Assuming your list starts in A1, first run the following macro and then sort columns A&B with B as the sort key.

Please Login or Register  to view this content.