View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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