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