I need to rearrange the information in a column. Help?
 

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?

I need to rearrange the information in a column. Help?
 

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?

I need to rearrange the information in a column. Help?
 

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?