Sorting by last digit
 

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

Sorting by last digit
 

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

Sorting by last digit
 

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

Sorting by last digit
 

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

wrote in message
ps.com...
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

Sorting by last digit
 

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

Sorting by last digit
 

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

" 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

Sorting by last digit
 

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


caldog wrote:
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

" 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