I need to sort the data in the column by the last few digits in the column
and not the first few. Is this possible?

You could insert a helper column to parse off the digits you want and then
sort on the helper column.

Insert a new column to the left of the data
Let's say you want the last 3 digits. Use RIGHT(A1,3) and copy the formula
down the column.

Now you can do your sort on the helper column.
--
Kevin Backmann


"lbrown" wrote:

I need to sort the data in the column by the last few digits in the column
and not the first few. Is this possible?

Say you want to sort by the last 4 digits of data in column A. In B1, enter:

=RIGHT(A1,4) and copy down

Then sort cols A & B by B
--
Gary''s Student - gsnu200835


"lbrown" wrote:

I need to sort the data in the column by the last few digits in the column
and not the first few. Is this possible?