Sorting by last digit

[pjamorton]

Hi All,

Happy New Year! Hope someone can help me! I am wanting to do a sort in
an excel data worksheet. The items in the column that I want to sort
look like ABC123 or else there are minor ones that look like ABC12L or
ABC12A, stuff like that. I know that if I just sort the column it will
sort by the first digit, being "A" in this instance. What I want to do
is sort by the last digit being either a number OR letter like "L". Is
this possible? My goal is to separate the ones that have letters at the
end. Thank you so much for any help given!! Jen

 

[pjamorton]

Yes I know about Data\Sort, but as far as I can tell it sorts by the
first digit, not the last. That is what I am wanting to do.

 

[David Biddulph]

Helper column =RIGHT(A1) and sort by that column.

 

[Dave Peterson]

You could split the last character into its own column and then sort your data
by that column.

=right(a1,1)

 

[Guest]

One way to do this is to use the Right command on the last digit.

Say your information is in Col A, use the right command in Column B, then
hi-light both columns, and sort on Column B.

Example: ABC123, =Right(A1,1)

Steve

 

[pjamorton]

Thank you all SO much! This worked like a dream! I really appreciate
it!! Jen