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

L

lbrown

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?
 
K

Kevin B

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.
 
G

Gary''s Student

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
 
Top