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
|