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