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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to sort a large column of 6 digit characters by the last character
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I sort a list of numbers by the last 4 digits? 2
How do I sort a column using the last number in the cell? 2
sort a cell by last two digits 4
Sorting or Filtering 5
Sort by last two characters, not the first. 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
I need to rearrange the information in a column. Help? 2
Numeric to character 3

Back
Top