Sorting a column...

[Nuyorican]

Good Afternoon,

I have a column with numbers for example, FRPSCL12509-5, FRPSCL497322-3, FRPSCL12442-7, etc, etc. ....The numbers will end with any number between 0 and 9. I would like to sort by that last number. Thank you.

Benito Torres

 

[liteblughost]

I think you may have to add an extra column and in that extra column you would use the RIGHT function.

=RIGHT(A1,1)
This returns the last character in the string.
Then sort by this last character column.