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

=right(a1,1)



wrote:

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.

Teethless mama wrote:
Data Sort

" wrote:

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



--

Dave Peterson