sorting by the last digit in a cell - how??

[nick qapmoc]

I know this may sound like a newbie question, but I need help.

I want to sort some cells based on the last digit of a cell.

example, I want all the cells with a 1 as a last digit seperated from the rest.

Thanks in advance??

[klb]

The easiest way I know is to create a formula in the far right column.

=right(yourcell,1)

Copy the formula down the column for the cells that you want sorted and then include that column in your sort.

It may not be elegant but it should work.

Good luck