How do I sort a column in Excel by the last digit in each field
 

I'm trying to sort a large column of 6 digit characters by the last character
in each field.

How do I sort a column in Excel by the last digit in each field
 

Add a column to the right of that column.

Use a formula like:
=right(a1,1)
to get that last digit.

Then sort your range by this column.

When you're done, delete this column.

jmdyt wrote:

I'm trying to sort a large column of 6 digit characters by the last character
in each field.

--

Dave Peterson